Solved

How to sum running % in an EXCEL column

Posted on 2014-09-05
6
173 Views
Last Modified: 2014-09-06
Hello -

I have a pivot table in EXCEL.  One column contains $ and the next % of those dollars to the total.
i.e.
Header   Amount  % of Total  Need calculation here
Row 1     $500           40%        40%
Row 2     $500           40%        80%
Row 3     $250           20%       100%
Total        $1,250       100%

This data is in a pivot table.  I would like to add a calulation in the pivot that would add each row's % of total (see need calculation here) header.

Any idea???
Thanks
Calc-needed.xls
0
Comment
Question by:vpopper
  • 3
  • 3
6 Comments
 
LVL 6

Expert Comment

by:johnb25
ID: 40306998
Hi,

See Attached.
In the Pivot Table Value Field Settings, on the Show Values As tab, select % Running Total In.


John
0
 
LVL 6

Expert Comment

by:johnb25
ID: 40306999
attachment
Calc-needed.xls
0
 

Author Comment

by:vpopper
ID: 40307559
OK - this seems to work for this data set but when I add additional data (a row 4) it changes the sum of % to a number???
Thanks
0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 

Author Comment

by:vpopper
ID: 40307572
Please see my revision - when I use the "Pivot Table Value Field Settings, on the Show Values As tab, select % Running Total In"  

I get N/A ???

Thanks
0
 
LVL 6

Accepted Solution

by:
johnb25 earned 500 total points
ID: 40308061
Hi,

In the Show Values As tab, have you selected x as the Base Field?
Selecting y gives #N/A.

John
0
 

Author Closing Comment

by:vpopper
ID: 40308065
Works now...not sure what the issue was.  Thank you very much!
I will be posting another question - perpahs you can help w that.

Thanks.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How to delete emails stored in my Hotmail account 10 47
Excel - Score or Rank 3 120
Is AWS.RDS considered a part of "Big Data"? 4 114
Excel Score Formula 5 65
MS Access 2003 or later To MySQL Migration Project Hello All, this is my second article in the category of MS-OFFICE Automation. In internet I am not able to find any comprehensive resource on the Migration of MS Access back-end to MySQL so I fin…
Lync meeting or Lync conferencing is what many organizations would like to deploy to allow them save money. But companies are now giving up for various reasons, one of which is that they cannot join external meetings (non-federated company meetings)…
Viewers will learn a basic data manipulation technique of unpivoting data in Power Query for Excel 2013 and the importance of using good data. Start with data in a poor structure: Create a table on your data: Unpivot columns: Rename columns: …
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question