This content has been marked as final. Show 3 replies
I need your help.I would like to calculate in a text field the sum of the revenues of my top 5 vendors.
No problem to do it in a pivot chart using the Rank function like : if(Rank(sum(Revenue))<=5,Sum(Revenue),0)
In the pivot chart, I can order by rank and calculate the sum of the Top 5.
I would like to do it now in a text field with a formula like : Sum ( if(Rank(sum(Revenue))<=5,Sum(Revenue),0) )
But it doesn't work.
is there some that could help me?