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.
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)