Hello everyone!
Can some guide me through the process of calculating differences between column values in a Pivot Table?
Refer to this image:
I want to add a column that shows the difference between Renewed Tickets in the two seasons displayed on the picture.
Hi Rosanna. I'm not near Tess at the moment so I'm doing this from memory but you are looking for filtered values in the Tess help to create your formula. Production Season is an assumption by me and I'm using Ticket Paid Count for an example ( SUM ( [Ticket Paid Count] ) , [Production Season] ) - ( SUM ( [Ticket Paid Count] ) , [Production Season] )
Right click on the Production Season and choose filter. Then you can choose "1920 ... ". Right click on the second Prod Season and do the same for "2021 ... "
I'd do them separate and then when you get it working then subtract one from the other
Hope that helps
H