Forum Discussion
Solved
Filter based on multiple values within the same column
The solution I am looking for varies slightly than what I have seen posted on here. I am looking to create a field/measure that I can use as a slicer to filter data based on its age category but I need the filter to be accumulating regarding its age. I would like to filter by the following:
- 3 Months
- 6 Months (I need it to include 3 Months data)
- 12 Months (I need it to include 6 months and 3 months)
Sample data:
| Opportunity Number | Stage | Date Closed | Closed Category |
| 11165 | Won | null | null |
| 10940 | Won | 8/17/2023 | 3 Months |
| 10619 | Won | 8/14/2023 | 3 Months |
| 9802 | Won | 4/26/2023 | 6 Months |
| 9921 | Won | 4/24/2023 | 6 Months |
| 10440 | Won | 4/21/2023 | 6 Months |
| 10441 | Won | 4/19/2023 | 6 Months |
| 10447 | Won | 4/18/2023 | 6 Months |
| 10316 | Won | 4/18/2023 | 6 Months |
| 10046 | Won | 1/25/2023 | 12 Months |
| 9883 | Won | 1/4/2023 | 12 Months |
| 9463 | Won | 12/28/2022 | 12 Months |
| 9783 | Won | 12/19/2022 | 12 Months |
| 9821 | Won | 12/14/2022 | 12 Months |
| 9827 | Won | 12/13/2022 | 12 Months |
| 9647 | Won | 12/5/2022 | 12 Months |
| 9690 | Won | 12/5/2022 | 12 Months |
| 9756 | Won | 12/5/2022 | 12 Months |
| 9745 | Won | 11/30/2022 | 12 Months |
| 8252 | Won | 11/28/2022 | 12 Months |
| 5857 | Won | 11/22/2022 | 12 Months |
| 9441 | Won | 11/18/2022 | 12 Months |
| 9113 | Won | 11/16/2022 | 12 Months |
rachaelwalker solution is attached, tweak it as you see fit.
1 Reply
rachaelwalker solution is attached, tweak it as you see fit.