2 Replies Latest reply on Jun 21, 2011 4:34 AM by 869738

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

      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..