![]() |
|
#2
|
|||
|
|||
|
Sample sheets are usually the best way to start off.
But let me see if I understand. Rather than 5, 2, 3 that the filtered pivot gives for total now, you want 6, 10, 8 which are the totals for the unfiltered report. Is that right? Since you are filtering for year, e.g. 2015, the other data are effectively invisible so I don't think you can get a total like that with the pivot. However, there may be more than one way to skin that cat. |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Pivot Table Help | asluder2000 | Excel Programming | 0 | 11-10-2014 09:28 PM |
| Pivot Table Question- Can the table display in the order the boxes were checked/selected? | blackjack | Excel | 0 | 09-13-2014 08:57 PM |
pivot table
|
aliasadi_07 | Excel | 1 | 03-11-2012 12:49 AM |
Help with a pivot table please!
|
natsha | Excel | 1 | 02-16-2012 12:41 PM |
Pivot Table
|
Karen615 | Excel | 5 | 08-03-2011 10:46 AM |