Get Free Trial

Filtering both labels and values

Massimo asked on March 1, 2021

I am looking for a way to filter pivot data by applying a filter by members’ name and, at the same time, another one by values. From a first analysis it seems that it is not possibile and that the two filters are alternative, isn’t it? Could you please help me to find out the right way for doing such a job?
Thanks in advance

1 answer

Vera Didenko Vera Didenko Flexmonster March 1, 2021

Hello, Massimo, 
Thank you for your question. 
You are right; at the moment, the Members and Values filters are alternatives – only one type of filter can be applied at a time for a certain field via the UI.
A possible solution is to apply the Members filter on the hierarchy and specify the Values filter in the report filters area. 
Here is a JSFiddle example for illustration:
Please let us know if such an approach would work for you.
Kind regards, 

Please login or Register to Submit Answer