Hi All,I am looking at the sales information for sales yesterday, specifically at the income from tickets sold below the base price (on a discount). The pivot I have set up has the line items are correctly calculating, however the the grand totals are not following the formula. When I remove either of the two variables mentioned in the formula from the rows section of the pivot, the results are the same as the grand totals, and unfair feels incorrect.
I am fairly new with tessitura, and was wondering if anyone might have any insight?
I think Christine is correct. The issue is that "Total Ticket Paid Value" is really SUM([Ticket Paid Value]). This means you are attempting to SUM an already SUM'd value. Whenever you see "Total" associated with a value, it means that it is really using the SUM function for the value. In other words, [Total Ticket Paid Value] = SUM([Ticket Paid Value]).