Ignore specific Dimension selection

[#1]

Hi All

i am displaying tickets per month.

Month as dimension, count ticket as expression.

i would to make a fixed table with all tickets per month so that if i selected a specific month, all the charts should be affected except that table. and this is for the month dimension only; i mean all the other selections should be applied.

e.g

Month, Tickets

Jan   3000

Feb   4000

Mar   3000

if i selected Feb in need to have the same above table

[whiteline]

Hi.

Use set analysis (refer to help).

Sum({<Month=>} Tickets)

[#3]

Hi whiteline,

set analysis will affect the # of tickets not the Month name.

i need to have all the months listed.

[whiteline · Accepted solution]

So you don't even bother to try ?

[#5]

thanks whiteline

i applied it on one expression although i have many expressions in the same chart. but i when i made a sample file, i understood.

thanks a lot again.

i need to read deeply what is set analysis.

[whiteline]

There are good examples of set analysis, refer to QV help.