Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

Fill the form
Get Free Trial

Filtering both labels and values

Answered
Massimo asked on March 1, 2021

Hello,
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
Massimo

1 answer

Public
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: https://jsfiddle.net/flexmonster/h4uzb3fw/.
 
Please let us know if such an approach would work for you.
 
Kind regards, 
Vera

Please login or Register to Submit Answer