Hi, I have a list of deals which are imports from salesforce opportunities which I need two things done to. Firstly i need them sorted by the close date and secondly i need a cumulative sum down the list so that i can tell what percentage of quota has been attained. Anyone know how to 1. sort the list based on a line item, and 2. do a cumulative sum based on the previous amounts?
Deal |
Close Date |
Amount |
Cumulative Sum |
1 |
6/11/15 |
10,000 |
10,000 |
2 |
5/1/15 |
10,000 |
20,000 |
3 |
1/1/15 |
10,000 |
30,000 |
4 |
3/1/15 |
10,000 |
40,000 |
Howard |
|
40,000 |
40,000 |
Cheers, H