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

[Anonymous]

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.

[lbendlin]

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