Skip to Content
0
Former Member
Jul 01, 2009 at 07:11 PM

How can i achieve this in Query Designer

39 Views

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.