how do i calculate cumulative percentages in Pivot table reports

  • Thread starter Thread starter Bala
  • Start date Start date
B

Bala

I want to calculate cumulative percentages for a calculated field item. Can
someone help me.
 
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

Calculating percentage growth rate from a cumulative figure 4
Pvt Tables - Custom Calculations - HELP ME!! 1
basic question - how to calculate a cumulative percentage? 3
How do I perform extended calculations in a Pivot Table in Excel 2 4
Cumulative time calculation in Excel 2003 2
Calculate cumulative elapsed time in Excel? 4
Percentages in Pivotal 3
Cumulative Sums in Pivot Tables 7

Back
Top