how do i calculate cumulative percentages in Pivot table reports

B

Bala

I want to calculate cumulative percentages for a calculated field item. Can
someone help me.
 
J

Joel

You would use =SUM(A1:A10)

the percenate is stored as a number 1% = .01

Adding the percentages will give the total percentages. You may need to
format the cell with the sum formula so it also will be in percentage.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

basic question - how to calculate a cumulative percentage? 3
How do I perform extended calculations in a Pivot Table in Excel 2 4
Calculate cumulative elapsed time in Excel? 4
Calculating percentage growth rate from a cumulative figure 4
Accumulated Percentage within a Pivot table....CAN ANYONE HELP?!?! 6
percentages 1
Percentages in a pivot table? 1
Pivot table in 2007 with bytes 1

Top