2 Replies Latest reply: Jun 20, 2011 11:34 PM by 869738 RSS

    Getting cumulative values in one column based on another column in reports

    869738
      Hi All,

      I have a requirement of getting the cumulative values based on another column.
      I have 'Sales rep name' in first column.
      Corresponding 'Invoice Line Values' in second column.
      Want to have cumulative of all Invoice line values for each sales rep.
      Then apply rank and display the top 10 sales reps based on invoice lines.
      Since there is no rank option in pivot table, I have to achieve this in report table.

      Looking for the best inputs...

      Thanx in advance..