Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

How to filter using columns and measures all in one slicer !

Hi team.

 

I have a table which has my COST and UNITS columns.

 

How can I select for a single Matrix from a filter which has options COST, UNITS and COST/UNIT (cost per unit or CPU).

 

If I unpivot the cost and units column then I get these 2 variables in Attributes and hence when I create a slicer with Attributes, I will get only 2 option to select from the slicer. They are Cost and Units.

 

Now how can I include Cost per unit as part of the options?

 

Thanks a lot.

1 Reply

  • Are you trying to use Field parameters?  Worst case you can create explicit measures from your COST and UNITS columns.