I am having trouble getting this pivot to work. The grand totals are off due to the divisor (Column I in Data) being used multiple times. However, if I restructure the data, the Installed Base (column I in Data) it doesn't appear everywhere I need it. Essentially, I need the Install base to appear in every year, region, paper grade, etc., but I need it to only be used once as the divisor. The current formula is Shipments in millions of sheets (Column K in Data) * 1,000,000 / For annual use calculation (Column I in Data) Can I make a formula that divides the divisor by the number of Paper Grades (column D in Data sheet)? Any help would me most appreciated as this is driving me nuts.
Please see the attached data sheet. This is not real data.
Thanks,
Scott
Test_Data.xlsx
Bookmarks