Last Year Sales and Current Year Sales for selected Year

[rishikeshtiwari]

Hi All,

I  am facing a challenge that I have a table in which there are sales according to the Launch Year.

We have Fiscal Year, Month ,Quarters Sales & Forecast sales in this table.

I have a requirement that a in a pivot table, [Current year and last year] sales should be calculate as per MonthYear dimension.

Suppose I have selected FY15 then Current year sales & Previous Year sales should be populate for FY [Jul 14-Jun 15].

I have created that cart using variable but when I am using that variable a new  Fiscal year FY14 also populated in the month-year

dimension. That I have not required. I want Prior Year sales should populate parallely with current Year Month-Year with

Current Year sales.

I have attached the data & Requirement also.

Please help.

[Gysbert_Wassenaar]

See attached qvw.

[rishikeshtiwari]

Hello Gysbert,

This is not my requirement. I want same as whatever I have attached in scrren shot.

On selection of one year two year should  not populate.

Please do the same as in screen -shot.

Thank you