set analysis - ignore one dimension and one selection

[#1]

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??

[swuehl · Accepted solution]

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

[#3]

It works, thanks a lot Stefan!