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?