Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, here is my problem:
I have a pivot table with 2 dimensions (Year-Month and Specialty).
I want to make a sum inside the table ignoring the specialty and the selected day, but not year and month.
To ignore one dimension set analysis would be: sum(<Specialty> total myCounter)
To ignore the selected day: sum($<Day = > myCounter)
But how can I combine both??
Set analysis will not consider the dimension value anyway, so I think it could look like:
=sum({$<Day= >} total<Year-Month> myCounter)
Note that I used a total specifier with given dimension, only Year-Month dimension will be used for grouping.
Hope this helps,
Stefan
Set analysis will not consider the dimension value anyway, so I think it could look like:
=sum({$<Day= >} total<Year-Month> myCounter)
Note that I used a total specifier with given dimension, only Year-Month dimension will be used for grouping.
Hope this helps,
Stefan
It works, thanks a lot Stefan!