Is it possible to hide a column measure by filtering for one of the values of a column field?
For example I have the color field column.
And the column measures "quantity" and "intensity"
if the value of the field column in the pivot table is "RED" I want to display only the values of the intensity and hide column quantity column.
if the value of the field column in the pivot table is "GREEN" I want to display only the values of the quantity column and hide column intensity.
if the value of the field column in the pivot table is "YELLOW" I want the values of the column quantity and column intensity.
I have attached an example
Thank you
Francesco
Hello, Francesco,
Thank you for contacting us.
Currently, Flexmonster does not provide a feature for hiding the measures based on members. Kindly note that it was intended to show all of the measure values for every member.
You are welcome to write to us in case further questions arise.
Kind regards,
Nadia
Thank you very much for the quick reply!
Kind regards,
Francesco