2 Replies Latest reply: Dec 1, 2011 12:58 PM by klaina RSS

    set analysis - ignore one dimension and one selection

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