Forum Discussion
Anonymous
4 years agoNot applicable
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
- lbendlin
Super User
Are you trying to use Field parameters? Worst case you can create explicit measures from your COST and UNITS columns.