Values changing on selection of filter in table qliksense

[Aspiring_Developer]

Hello All,

I have below table :-

As of now, it is giving me desired output.

Expression used :-

Sum(Volume)/
sum({<Brand-={'Total Market'}>}total  Volume)

I am facing below issue :-

1) On Month year selection my values are changing like below :-

So, in order to restrict that I used below expression and the issue got rectified :-

Sum(Volume)/
sum({<Brand-={'Total Market'}>}total <MonthYear> Volume)

2) On brand filter selection , values are changing like below :-

I tried using below expression but it did not worked :-

Sum(Volume)/
sum({<Brand-={'Total Market'}>}total <MonthYear, Brand> Volume)

Can anyone please help ?

My filter should not change my numbers . What should i do for brand filter ?

Thanks in advance

@hic 

[MayilVahanan]

Hi

For ignore the few selection, try like below

Sum({<MonthYear=, Brand=>}Volume)/
sum({<MonthYear=,Brand-={'Total Market'}>}total  Volume)

Complete ignore, try like below

Sum({1}Volume)/
sum({1<Brand-={'Total Market'}>}total  Volume)

[Aspiring_Developer]

Hi @MayilVahanan 

I tried above but it didn't worked.

[MayilVahanan]

Hi

Can you post the sample data or file?