Forum Discussion
Fliter dataset
then pls update your sample data and expected output
here is data
Filter date which is single select date, this is from the table
Here is my dataset where i want to fliter for last 9 days whenver they select date.
order date item number price
1 03/03/2025 1 50
2 03/04/2025 2 60
3 03/03/2025 3 70
4 03/04/2025 4 80
5 03/06/2025 6 90
6 02/01/2025 7 90
when i select 03/06/2025 i want to go all back with -9 order date it ilike paramter in SSRS to get filter from dataset from selected date all backward to 9 days
i am doing matrix
Item number 02/26/2025 .......03/03/2025 03/04/2025 03/05/2025 03/06/2025
1 0 50 0 0 0
2 0 0 60 0 0
3 0 70 0 0 0
4 0 0 80 0 0
5 0 0 0 0 90
in this we should notget 02/02/2025 date at all which is not < 9 days