|
|
|
|
#1
03-20-2020, 06:04 AM
|
||||
|
||||
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 |
Windows 10 
Office 2019
Hybrid Mode