Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
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?
Thanks.
Look at this thread:
Does this help
Could you expand on question 2,please?
It worked !!
So much happiness 🙂
Good to hear.
If you happy with the answer could you mark the question as answered ,please?