Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI Experts
In my Pivot table, Using a calculated Field Difference
Difference = ([last month Sales] - [Current month Sales])
now i want to choose on top 5 values by Ascending order
Please Suggest
Hi..
Try like this exp below using aggr():
=IF(Aggr(Rank(Sum(UnitPrice)),DivisionID)<=5,Sum(UnitPrice))
Try to modify this with your expression
Thanks
It may be work
=Aggr(If(Rank(Sum(Sales)-Above(Sum(Sales)))<=5,Month),Month)
sum(aggr(if(rank(sum ([last month Sales]) - sum([Current month Sales]),4)<=5,sum ([last month Sales]) - sum([Current month Sales])), Dimension))
HI
I am using a Straight Table
Sorry Not using a Pivot table
Please Suggest
Hi John,
Please try above responses, if they doesn't help your query, please post sample app
Hi,
why not you go for dimension limits option?
Hi John,
You can restrict Top 5 values in Dimensions Limits tab. Check it once. If it don't work out please upload sample app.
Hi,
For that calculated expression you can set limit=top 5 from Dimension limit tab
Hi John,
You can try with Dimension limits in the chart properties or use the rank function .