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?