Subtotals and Grand Totals That Add Up "Correctly"

Sales per Day Measure

Check out this relatively simple pivot:

Note that the subtotals for [Sales per Day] do not equal the sum of their parts. 2002's total is $17,891 but if I add Mountain Bikes plus Road Bikes myself, I get a number closer to $19,000: