How to plot X axis YearMonth with CY sales with LY sales ?

[paulyeo11]

Hi All

I like to create the chart 1

My issue is i don't have the expression for LY.

My Objective for create this chart is , so that i am able to compare CY sales vs LY sales by month.

Hope some one can give me the expression. ( Now i using sum(cost) is not correct.

Enclosed my QVW file.

Paul

[jagan]

Hi,

Just change Month to MonthYear as dimension.

Regards,

Jagan.