This discussion is archived
2 Replies Latest reply: Jun 20, 2011 9:34 PM by 869738 RSS

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

869738 Newbie
Currently Being Moderated
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..

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points