Hello, all Experts!
Does anybody know how to add a calculated field showing cumulative percentages per row on a Pivot Table?
I'm working on a delivery report showing delivery times (=delivered before 8:00 AM, delivered before 9:00 AM etxc.) and I can see the actual percentages per customers / cities etc. but rather than seeing that 10 % of the shipments for Customer A were delivered before 8:00 AM and 8 % of the shipments were delivered between 8:00 AM and 9:00 AM I'd like to have a calculated field telling me that 18 % of the shipments were delivered by 9 AM and 85 % by noon.
Anybody know the formula for the calculated field?
Does anybody know how to add a calculated field showing cumulative percentages per row on a Pivot Table?
I'm working on a delivery report showing delivery times (=delivered before 8:00 AM, delivered before 9:00 AM etxc.) and I can see the actual percentages per customers / cities etc. but rather than seeing that 10 % of the shipments for Customer A were delivered before 8:00 AM and 8 % of the shipments were delivered between 8:00 AM and 9:00 AM I'd like to have a calculated field telling me that 18 % of the shipments were delivered by 9 AM and 85 % by noon.
Anybody know the formula for the calculated field?
