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.
|