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
Thank you for your question.
You are right; at the moment, the
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.