Data is not filtering

[Luke_Killer_IT]

Hello
I have a problem with data filtering, it does not work as shown in the screenshot, what could be the reason? and how to solve it?

[MayilVahanan]

HI

Might be, ur expression exclude the fields selection..

[Luke_Killer_IT]

Mayil

how to check?

[Luke_Killer_IT]

Mayil
look at this when i click sort like this

it  works  but this filter gets from another table which is not even displayed while in pivot table I only have data from two tables but they are linked and can't filter them, listbox is from this table which is in pivot table.

[MayilVahanan]

Hi Luke,

Can you attach ur sample qv file?

OR can you paste ur expresssions?

[Luke_Killer_IT]

Hi Mayil,

I don't know if you meant that

[MayilVahanan · Accepted solution]

Hi

In ur first expression, change the expression like below to impact ur selection

Sum({<ArticleGroup*={510,520, 530}>}OnHand)