Hi
Please update me how can i achieve this.
In my Query
Rows:
I got a structure with 52 elements each represents a Restriction on Cal Week/Year using Value range
Row 1 represent Restriction on Cal Week/Year using Value range
Row 2 represent Restriction on Cal Week/Year using Value range
Row 3 represent Restriction on Cal Week/Year using Value range
Row 4 represent Restriction on Cal Week/Year using Value range
Row 30 represent Restriction on Cal Week/Year using Value range
Row 40 represent Restriction on Cal Week/Year using Value range
Row 52 represent Restriction on Cal Week/Year using Value range
In Column:
I had a Key Figure
My requirement is
Based on Current Cal Week No......for example
If Current week no is 26
Then when user execute the report then
Output should be from 1 to 26 elements only out of 52 elements
If Current week no is 45
Then when user execute the report then
Output should be from 1 to 45 elements only out of 52 elements
If Current week no is 01
Then when user execute the report then
Output should be 01 elements only out of 52 elements
Please update how to achieve this.