Hi!
Table #1 is given, and shows a snapshot of how many customers have recieved a various number of shipments, from shipment 1-7.
I need help with calculating table #2, showing how many shipments there are at each shipment level, for shipment 1, all customers in 1-7 has recieved a 1st shipment, = 84, and for 2nd shipment, it shall calculate the sum of shipment 2-7. and so on.
Table #3 shall calculate the average shipments at each shipment level, at shipment 1 it is, 84/84 and for shipment 2 it is 75/84 and so on.
Table #4 shall calculate the drop of at each shipment, at shipment 1 it is, (1,00/1,00)-1 and for shipment 2 it is (0,89/1,00)-1 and so on.
Thanks for any contributions.
/Eric
| Pivot Table #1 |
| Shipment number | # of customers | |
| Total | 84 | |
| 1 | 9 | |
| 2 | 10 | |
| 3 | 14 | |
| 4 | 13 | |
| 5 | 21 | |
| 6 | 8 | |
| 7 | 9 | |
| Pivot Table #2 |
| Shipment number | # of shipments | |
| Total | 339 | |
| 1 | 84 | |
| 2 | 75 | |
| 3 | 65 | |
| 4 | 51 | |
| 5 | 38 | |
| 6 | 17 | |
| 7 | 9 | |
| Pivot Table #3 |
| Shipment number | Avg shipments per customer | |
| Total | 4,04 | |
| 1 | 1,00 | |
| 2 | 0,89 | |
| 3 | 0,77 | |
| 4 | 0,61 | |
| 5 | 0,45 | |
| 6 | 0,20 | |
| 7 | 0,11 | |
| Pivot Table #4 |
| |
| Shipment number | Drop-off at each shipment | |
| Total | -0,42 | |
| 1 | 0% | |
| 2 | -11% | |
| 3 | -13% | |
| 4 | -22% | |
| 5 | -25% | |
| 6 | -55% | |
| 7 | -47% | |
