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!
So you have two different "ticket paid" in use - Package is using Ticket Paid Value Production Season is using Ticket Paid Amount. which are slightly different value is "due" where amount is "paid" when i made them the same my widgets match.