Calculate attrition rate and customer contribution at each shipment level

[#1]

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%