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,
That is exactly what my solution does. I have shared the file with you.
Ashish_Mathur No, It is not working.
If you select "within 1 month" no data is shown.
Hi,
In the "Months since started" column, there is no entry of 1. Therefore when you select "Within 1 month" in the slicer, no row shows up.