1. I am looking to find max of sum of sales by category. I am using 'Max(sum({<[Expense Category]=>}Sales))' which is not correct of course (I feel like stupid putting this up). I have used set analysis because I do not want this value to be altered by other selections.
2. Is there any way we can create an array of selections and then use it elsewhere?
