CODEWITHSUNDEEP
excelpivot-tablepercentagecumulative-sum
Michael
Michael

Reputation: 1381

Cumulative Row percentage in pivot table Excel

I would like to summarise the data using a cumulative row percentage while the row is aggregated by year-month. I posted a screenshot of the "raw data" and the aggregated data below. So in the second screenshot I would like to see the cumulative row-percentage per year/month.

I tried the "value as" options, but didn't find anything that worked.

enter image description here

enter image description here

Upvotes: 1

Views: 6610

Answers (1)

jeffreyweir
jeffreyweir

Reputation: 4824

To display running percentage totals, you normally just right click on the Values field, select Show Values As, then choose % Running Total In.

Upvotes: 2

Related Questions