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

reports run 4.xls (21.0 KB, 15 views)