Forum Discussion
How to subset a table using slicer?
I have the above dataset with two fields, QTR GTN % and QTR CV %
I need to create a slicer with these two columns with specific conditions for each.
For example, if I click on QTR GTN %, it will subset by table above to all rows with a QTR GTN % > 0.4 or QTR GTN % <-0.4.
If I click on QTR CV %, it will subset by table above to all rows with a QTR CV % > 0.1 or QTR GTN % <-0.1.
Once I make the selection on my slicer I want my graph of unique sales_doc_numbers by profit center to also change based on the new subset table. How do I do this?
2 Replies
- wdx223_Daniel
Community Champion
Anonymous think you can create a dim table and use it in a slicer, then use Switch or IF to control you calculation
or create a calculation group
wdx223_Daniel Do you think you could provide a sample code on how to do this. I have tried to create another unrelated table and add a measure with an if statement but it's not working for me
