I'm looking for help creating a simple bar chart that will show me the number of unique performances per season in which the sum of total paid/reserved tickets and total comps exceeds a certain number...but can't figure out quite how to build the necessary formula. (I currently have a workaround with a pivot table that is filtered from largest value to smallest, but would like something a little more elegant to show my executive leadership.) Does anyone have any ideas or suggestions on how this might be accomplished within Analytics?
Thank you!Anh