Hey folks,
I'm struggling with a formula in analytics
I'm looking at revenue by source for each Prod Season.
I'm trying to create a formula that will calculate the % of total Prod Season Revenue a Source brings in and from the documentation on the ALL Function I thought SUM ([Ticket Paid Amount]) / ( [Total Ticket Paid Amount] , ALL ( [Source] ), ALL ( [Appeal] ) ) should work
Any thoughts?
Hi Heath,
Double check that the Source and Appeal fields between the pivot table rows and the value filters are all from the same source field collection: the ORDER or the LINEITEM, because that looks like it should work:
Best,Chris
Chris Wallingford Director, Business Intelligence Tessitura Network Office +1 888.643.5778 ext 553 chris.wallingford@tessituranetwork.com Tessitura Learning & Community Conference July 28-August 1, 2019 #TLCC2019
Thanks Chris. I've rebuilt the formula values and it works a treat.