• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 179
  • Last Modified:

How to sum running % in an EXCEL column

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
vpopper
Asked:
vpopper
  • 3
  • 3
1 Solution
 
johnb25Commented:
Hi,

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


John
0
 
johnb25Commented:
attachment
Calc-needed.xls
0
 
vpopperAuthor Commented:
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
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
vpopperAuthor Commented:
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
 
johnb25Commented:
Hi,

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

John
0
 
vpopperAuthor Commented:
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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now