Forum Discussion
Two or More date Filters for the same data
I have Data from a View and I want to filter the data with three date ranges. Not necessarily the same date previous year etc. For the same field "Status Date". Eg: Filter1 Date Range: 01-01-2005 ...
Hi Anonymous ,
Kindly check the attachment whether help.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
I did not find @amitchandak acceptable.
I have a table and three slicers
| slicer 1= | 1/1/2000 | to | 9/1/2000 |
| slicer 2= | 1/1/2002 | to | 11/1/2002 |
| slicer 3 = | 9/1/2003 | to | 5/1/2004 |
Table:
| Id | Cost | Date |
| 1 | 273 | 1/1/2000 |
| 2 | 41 | 3/1/2000 |
| 3 | 41 | 5/1/2000 |
| 4 | 48 | 7/1/2000 |
| 5 | 386 | 9/1/2000 |
| 6 | 241 | ######## |
| 7 | 158 | 1/1/2001 |
| 8 | 54 | 3/1/2001 |
| 9 | 349 | 5/1/2001 |
| 10 | 203 | 7/1/2001 |
| 11 | 130 | 9/1/2001 |
| 12 | 355 | ######## |
| 13 | 98 | 1/1/2002 |
| 14 | 310 | 3/1/2002 |
| 15 | 362 | 5/1/2002 |
| 16 | 263 | 7/1/2002 |
| 17 | 159 | 9/1/2002 |
| 18 | 194 | ######## |
| 19 | 220 | 1/1/2003 |
| 20 | 140 | 3/1/2003 |
| 21 | 74 | 5/1/2003 |
| 22 | 93 | 7/1/2003 |
| 23 | 144 | 9/1/2003 |
| 24 | 211 | ######## |
| 25 | 396 | 1/1/2004 |
| 26 | 240 | 3/1/2004 |
| 27 | 281 | 5/1/2004 |
The results should be in the detail report:
| Id | Cost | Date |
| 1 | 273 | 1/1/2000 |
| 2 | 41 | 3/1/2000 |
| 3 | 41 | 5/1/2000 |
| 4 | 48 | 7/1/2000 |
| 5 | 386 | 9/1/2000 |
| 13 | 98 | 1/1/2002 |
| 14 | 310 | 3/1/2002 |
| 15 | 362 | 5/1/2002 |
| 16 | 263 | 7/1/2002 |
| 17 | 159 | 9/1/2002 |
| 18 | 194 | 11/1/2002 |
| 23 | 144 | 9/1/2003 |
| 24 | 211 | 11/1/2003 |
| 25 | 396 | 1/1/2004 |
| 26 | 240 | 3/1/2004 |
| 27 | 281 | 5/1/2004 |
Any suggestion on how this can be achieved?