A Slider filter (or something similar) in order to limit data in pivot table for "min" and "max" value (that customer will choose by his own).
How to perform that if I have to consider at least 3 dimensions (Eg. "InitiativeName", "Brand" and "Places") and 2 fields (Eg. "Sales" and "Pieces")?
- It's not necessary to filter 3 dimensions at same time;
- the 2 fields are already available as an orphan table called "SalesPieces", which contains both fields, that I am using as desired with a connected variable. (vSalesPieces);
My problem: I don't know how to create right expression;
The main idea I suppose should be somewhat like Aggr(InitiativeName,$(vSalesPieces)>=vSlider) (in the "Data" field of slider properties - "Expression") - (where variable "vSlider" should contains the relative value from the user in the input box for min and max).
I found a lot of discussions, chiefly referred to "Date/Month" period. I tryed to convert in Value/Pieces but I just make a real mess.
Lost the way...need someone who could bring me back to the right way .