View Single Post
 
Old 01-15-2015, 01:48 PM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

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.
Reply With Quote