#1
|
||||
|
||||
Pivot totals / subtotals
I've got a pivot table that correctly calculates a cumulative % of the total number of items being counted. BUT, when I filter the pivot, the percent of total column calculates using unfiltered total. How can I get the % of total to use the filtered total in the calculation?
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Summary page of totals? | srussell | Mail Merge | 1 | 08-13-2019 11:16 AM |
Trying to find a way to calculate subtotals for different sections of an invoice w/ data validation | excerbated123 | Excel Programming | 2 | 02-03-2015 09:28 PM |
Multi Level Subtotals w 2 Grand Totals That Don't Match | DavidW | Excel | 3 | 10-09-2014 07:08 AM |
Can I sort a Pivot table by subtotals? | oshkosh | Excel | 1 | 12-07-2010 06:20 PM |
Using subtotals in Pivot table formulas | ninfanger | Excel | 3 | 10-23-2010 12:29 AM |