Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good day,
I need to have a toggle - when not selected will display all the data in a straight table, however when selected to exclude the top 15% and bottom 15% of the calculated expressions in the straight table ... please assist and guide me in the right direction.
Thanks Chris
You could try to get an acceptable view of your data with using the restriction tab of the straight table. This meant displaying the area between top and flop would be not possible but many other views are possible especially if variables will be used for the restiction values/borders.
If this isn't enough you will need to use calculated dimension like this one:
Aggr( If((Rank(Sum(Sales),1)-1) / Count(distinct total Product)< 0.50, 'A',
If((Rank(Sum(Sales),1)-1) / Count(distinct total Product)< 0.75, 'B', 'C')),
Product)
from the blog: Recipe for an ABC Analysis which provided many more ideas to these topic.
- Marcus