Filtering isn't working

[#1]

why I cannot filter? In the chart "Conteggio Articoli Campionati" if I filter and article (i.e. 9ODO60147) the filter doesn't apply...can someone explain me why???

[julian_rodriguez · Accepted solution]

Found it!!

On the expression "Qtà" says:

=Count ({<[Codice Articolo]>} [QTA 1 Campionature])

The set analisys is ignoring all the selections made on the field "Codice Articolo"

You should use instead:

=Count ([QTA 1 Campionature])

Regards

Hello Irene

Could you try please, create one field named for example "Codice Articolo 2", with the same definition of "Codice Articolo"?

I have seen this before, and I have needed to change the field name, with any reason or knowing why.

Regards

[#3]

I liked your answer but I need to calculate the QTA1_Campionature with respect to the 'Codice Articolo' variable. If I remove it as you suggested it gives me a wrong result.

[#4]

My apologies @Julian Rodriguez. I didn't filter correctly, the result is the same! thank you very much for your help!

[julian_rodriguez]

You are very welcome Irene!

Regards!