Hello all,
We are trying to convert one of our spreadsheets to an analytics pivot table.
Here is an example of the part of the current sheet we are trying to replicate:
Each row is for a different end user or solicitor.
The Sold column counts our main four ticket types sold, admission, concession, student and senior.
The Donation column counts tickets sold with a donation ticket layer, admission + donation, concession + donation.
The Percentage column shows the % difference between Sold vs Donation.
Can anyone give us a steer on creating this?
Hi George,
Using Filtered Values for Sold might look like this:
( [Total Ticket Count] , [Price Type in admission, concession, student and senior] )
Given that Ticket Count is only flagged as "1" on Ticket Price layers, the Donation piece might look like this:
( [# unique SLI ID] , [Price Layer in admission + donation, concession + donation] )
And then the percentage as...
( [# unique SLI ID] , [Price Layer in admission + donation, concession + donation] )/ ( [Total Ticket Count] , [Price Type in admission, concession, student and senior] )
Thanks Chris this is exactly what I was looking for!