In creating a subscription sales dashboard, I've happened upon a perplexing situation, in which total paid amount by Package differs from total paid amount by Production Season, for the same 5 packages. The pivots are below.
TicketPaidAmountExample.dash
This dashboard is filtered to five packages, and that is the only filter. Yet the total by Package Code (at top) is $593,748.25 and by Production Season is $597,491.47. I believe these amounts should match.
Does anyone know of a reason for this difference? The .dash file is attached.
Thanks in advance for any help!