Solved

How to sum running % in an EXCEL column

Posted on 2014-09-05
6
171 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
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

I wanted to share this with fellow Experts, who might not know. How often have you wanted to learn something, only to be set back by either restrictions imposed on "trial" or "evaluation" software?  How often have you had to rebuild a home networ…
This collection of functions covers all the normal rounding methods of just about any numeric value.
Viewers will learn a basic relationship technique in Power Pivot for Excel 2013.
Video by: Zack
Viewers will learn the basics of using Excel Tables, the benefits found with them, and some pitfalls.

862 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

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now