T
tevawe
In my pivot table I am calculating the number of orders & the % of orders
that are created each month that have a certain criteria. Within the pivot
table a can also create a running total (accumulated) of orders, but now I
want to calculate a running % (accumulated) For example, in January I
released 100 orders. Of those 100 order 8% were created with a leadtime of
less than 30 days, 12% were between 30 & 60 days, 10% between 60-90 days, 15%
between 90-120, the remaining 55% were greater than 120 days. Within my
pivot table I want to add 8% + 12% + 10% + 15% so I can track what percentage
of my orders were created with what amount of leadtime. How can I do this?
I don't think adding a helper field to my source data.
that are created each month that have a certain criteria. Within the pivot
table a can also create a running total (accumulated) of orders, but now I
want to calculate a running % (accumulated) For example, in January I
released 100 orders. Of those 100 order 8% were created with a leadtime of
less than 30 days, 12% were between 30 & 60 days, 10% between 60-90 days, 15%
between 90-120, the remaining 55% were greater than 120 days. Within my
pivot table I want to add 8% + 12% + 10% + 15% so I can track what percentage
of my orders were created with what amount of leadtime. How can I do this?
I don't think adding a helper field to my source data.