View Single Post
 
Old 10-22-2010, 02:31 PM
ninfanger ninfanger is offline Windows XP Office 2007
Novice
 
Join Date: Oct 2010
Posts: 2
ninfanger is on a distinguished road
Default re: Using Subtotals in Pivot Table formulas

A picture is worth????

The attached spreadsheet [reports run 4.xlsx] shows the pivot results for 3 of many clients. It shows; (A) Client Name, (B) which reports that client ran, (C) how many of each report were run, and (D) the % of the entire report. (Client #2 then ran 2.69% of all reports included in the pivot.)

I manually created Column E to show what % each report type is of the related Client's total reports. (ie: 37% of Client #1's reports are Report C.) I want the Pivot table to generate Column E.

I think the answer is a Calculated Field that counts the instances of each report type for a client and devides that by the total count of reports for that client.

Hopefully that is less obfuscated.
And truly thank you for any help you can offer.
Attached Files
File Type: xls reports run 4.xls (21.0 KB, 15 views)

Last edited by ninfanger; 10-22-2010 at 02:46 PM. Reason: Pasting the table displayed as code not graphic. The Illustration is now a simple spreadsheet.
Reply With Quote