calculated dimensions - ignore selections

[idogridish2]

Hello everyone,

I have a pivot table that has five dimensions,

and I want to ignore only one dimension  when selecting.

photo attatched.

the name of the field is [campaign desc].

i want to be able to select dates but not the [campaign desc].

only filer by year month week and day

thanks in advance.

[swuehl]

Not sure if I understand. How does your expression in the pivot table looks like?

In general, you can ignore selections in fields using set analysis:

=Sum({<FIELDTOIGNORE= >} Value)

and you can ignore dimensions in a chart using TOTAL qualifier, by listing only dimensions you want to consider;

=Sum(TOTAL Value)

Or

=Sum(TOTAL<Year, Day, Month, Week> Value)

[idogridish2]

Thank you very match it worked!

בתאריך 27 בינו' 2016 23:24,‏ "swuehl" <qcwebmaster@qlikview.com> כתב: