Skip to Content
0
Apr 27, 2018 at 09:30 PM

Neither %GT in Analysis office or Constant selection meet requirement

144 Views Last edit May 02, 2018 at 12:52 PM 3 rev

Hello Gurus,

It is a know issue that %GT does not work in Analysis office when using OLAP connection https://launchpad.support.sap.com/#/notes/1951436 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?