Set Analysis Expression

[sona_sa]

Hi Team, Below is my chart and pivot table. I have two list box, 1. Year Month and 2. Role

In My Pivot Table 3 dimension and 1 expression.

1 Category --> If(wildmatch(Role,'External*'),Role)

2. Sub Category

3. Year Month

Expression : Sum(Value)

Now suppose if I make any selection in Year Month or Role, Figure not affected in Pivot Table and Chart. So need expression for the same. Please find the attached QVW for more reference.

[GaryGiles]

Are you trying to ignore selections made in Year Month and Role?

If so, you would use:

sum({$<[Year Month]=,[Role]=>} Value)

[sona_sa]

For Year Month it is working but when I am making a selection for role it is not working. On selection of Year Month Below is output

On Role Selection Below is output :

Thanks

[sona_sa]

Hi Gary,

Please find the attached QVW for refence.

Thanks