Webi LY Values for WTD MTD, QTD and YTD are not changing

[e_c]

Hi Experts,

I have a webi report and the issue is the data is not getting refreshed when i select a different value in the input control.(Input control -- combo box)

Input control values

a

b

c

for example consider the below Report output when selected input control value a.

Structure value Curr wtd Last yr wtd curr mtd last yr mtd curr qtd last yr qtd

Box 11 44 77 10 13 16

Mat 22 55 88 11 14 17

chair 33 66 99 12 15 18

when i select input control value b the values are not changing in the last year columns and the values are changing for the other columns which is correct.

Structure value Curr wtd Last yr wtd curr mtd last yr mtd curr qtd last yr qtd

Box 19 44 22 10 25 16

Mat 20 55 23 11 26 17

Chair 21 66 24 12 27 18

Why the values in the last year columns are not getting updated as per the value selected in the input control.The values in the current and last year columns are measure values. The table is a vertical table in the webi report and the backend source is a BEx query which has a structure with values such as box, mat, chair etc...

Any inputs are highly appreciated. Thanks in advance.