Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all,
Top 5 fruits selection not working in Pivot and Line chart. please find the attached samples.
TIA
Hi,
You can achieve in many ways,
1) Calculated dimension
=aggr(only({<Fruits={'=rank(sum(Sales))<=5'}>} Fruits),Fruits)
or
=aggr(if(rank(sum(Sales))<=5,Fruits),Fruits)
2) Calculated measure using set analysis
SUM({<Fruits = {"=Rank(SUM(Sales),4)<=5"}>}Sales)
or using aggr function
if(Aggr(Rank(Sum(Sales)),Fruits,Month)<=5,sum(Sales))
3) Using Dimension Limit (straight table)
Dimension Limits tab --> Fruits dimension, Select Show only Largest 5 Values
4) back end script method
What is your expected output should be ?
only top 5 sales should be visible in both the charts
Hi,
You can achieve in many ways,
1) Calculated dimension
=aggr(only({<Fruits={'=rank(sum(Sales))<=5'}>} Fruits),Fruits)
or
=aggr(if(rank(sum(Sales))<=5,Fruits),Fruits)
2) Calculated measure using set analysis
SUM({<Fruits = {"=Rank(SUM(Sales),4)<=5"}>}Sales)
or using aggr function
if(Aggr(Rank(Sum(Sales)),Fruits,Month)<=5,sum(Sales))
3) Using Dimension Limit (straight table)
Dimension Limits tab --> Fruits dimension, Select Show only Largest 5 Values
4) back end script method