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
⋅ 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
This question is now closed
