Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Maybe its just the syntax that's screwing me up. My issue is i want to do the set analysis say for Year=2016, and Month=Jul, exluding all selections.
Sum({1<[Year]={'2016'}>*<[Month]={'Jul'}>}Sales)
This behaves the same way with or without the 1. The year and month sets work on their own, and if i combine the 1 with only one field of set analysis it works, but not all at the same time.
Any Ideas?
Thanks
Try this:
Sum({1<[Year]={'2016'}, [Month]={'Jul'}>}Sales)