3 Replies Latest reply: Jan 31, 2012 2:16 AM by Médéric Eloy RSS

    Calculate the Top 5 Vendors' revenue in a field, not in a chart

      Hi All,

      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?
      Many thanks.