Forum Discussion
Slicer With single selection
Hi, I have a data like below, where "Months Since Started" is months difference with current date => (TodayMonth - startDateMonth) Now i want to have slicer on report which filters 1. Contract ex...
Here is my sample data.
| Device | Contract Start Date | Months Since Started |
| A | 17-Dec-19 | 3 |
| B | 21-Sep-18 | 18 |
| C | 15-Oct-19 | 5 |
| D | 14-Jan-20 | 2 |
| E | 16-Sep-19 | 6 |
| Index | Contract expirying |
| 1 | with in 6 months |
| 2 | with in 3 months |
| 3 | with in 1 month |
So Slicer should filter table as below.
1. Contract expirying "with in 6 months" => Shows Devices = A, C, D, E
2. Contract expirying "with in 3 months" => Shows Devices = A, D
3. Contract expirying "with in 1 month" => Shows Devices = C, E
Hi ravitejaballa ,
Yes, as Ashish_Mathur mentioned , the"within 1 month" option should return blank(the date which within a month of today is 202/2/29-2020/3/31, no records within this range, it should return blank). Or you also could inform me your logic of "within 1 month", then we will help you more correctly.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.