Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone ,
Good Morning. I am creating a Pivot Table with the help of below calculated dimensions.
=if(vSlider = 0,Product,if(Aggr(Rank(TOTAL Sum( Sales ) ), Product) <=vSlider,Product))
=if(vSlider = 0,Group,if(Aggr(Rank(TOTAL Sum( Sales ) ), Group) <= vSlider,Group))
And I am using the below expression
Sum({<Year={2017},Product=,Group=>}Sales)
I am using slider to get the top values from 5 to 30 separated by 5.
When i use a single dimension, the pivot table and Top analysis works fine and similarly when i use more than one dimension it doesn't works.
For Example , If i use only Product as a first dimension then it works and if i expand the pivot table with the second dimension, the top analysis doesn't works.
Suppress when value is null is checked.
Kindly help me on the above scenario.
Best Regards,
Siva
try to add your Dimension in the aggr() function:
Aggr(Rank(TOTAL Sum( Sales ) ), Product, secondDimension)
i have not tested that. Eventually you Need build a condition
if(dimensionality()=1, aggr(..., Product),
if(dimensionality()=2, aggr(..., Product, SecondDimension),
try to add your Dimension in the aggr() function:
Aggr(Rank(TOTAL Sum( Sales ) ), Product, secondDimension)
i have not tested that. Eventually you Need build a condition
if(dimensionality()=1, aggr(..., Product),
if(dimensionality()=2, aggr(..., Product, SecondDimension),
Would you be able to share a sample to look at the issue?