Skip to Content
avatar image
Former Member

Neither %GT in Analysis office or Constant selection meet requirement

Hello Gurus,

It is a know issue that %GT does not work in Analysis office when using OLAP connection I have used constant selection method as an alternative. However the % contribution in constant selection method only works when you are looking at over all results. It is not dynamic and does not update when I filter on the report.

eg. When you look at % contribution of one Customer over 5 Countries % GT( Constant selection) is 2%. When I filter the report to just that customer's country %GT( Constant selection) stays at 2% instead of updating to 10%.

As such the %GT and %GT constant selection are not the same and the later does not meet my requirement. Any ideas on how to make constant selection dynamic?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Apr 28, 2018 at 11:52 AM

    Hi Thomas - what about using Excel functions and not the Analysis Office ones? See

    Add comment
    10|10000 characters needed characters exceeded