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?
Hi Bryn,What is likely happening is the grand totals are also referencing your formulas. If you click on the three dots next to your value, you can find other options for "Subtotal By." Try selecting "Sum" rather than the "Auto" default and see if that does the trick!Happy analyzing!Christine