Display previous months data

[#1]

Hi all

Please find attached .qvw and its supporting data.

I am looking to display all the 'Locations' value when Year/Month is selected.

Display all locations and its value.

Example:

When 2012 and June is selected table shows only' HongKong' with 'Value' 36 but I would like it to display all the 'Locations'. There is a lookup file 'Target' that has a field 'Months_Behind' therefore when Year=2012 and Month=June the table should display

HongKong           36           (as Months_Behind = 0 for HongKong, as June is selected it displays June's value)

London               38           (as Months_Behind = -1 for London, as June is selected its june -1 month wiz May's value) 

NewYork            25           (as Months_Behind = -2 for NewYork, as June is selected its june -2 month wiz April's value)

California            13           (as Months_Behind = -3 for California, as June is selected its june -3 month wiz March value)

Thank you.

[MK_QSL]

attachment is missing

[#3]

Sorry. Please see attached.

[#4]

hi,

     if i am right then you don't want any changes according to year or month selection. You want to show all records.

and according to your excel sheet you are displaying max value for every location.

for that use this expression in chart:

=Max({$<MonthName=,Year=>} Value)

hope this helps.

Regards,

Ashutosh

[#5]

True but it gives me Max value rather than giving the latest value.