Month comparesion

[#1]

i have 12 months data for sales, pages,visit,view .

i want to show comparesion between months

like when user select march , chart will show data for march as well as feb only two monts at a time.

i need help ,how to show this in chart.

[masha-ecraft]

Make a chart with two expressions: sum(Sales) for the selected month and sum({<Month=Month-1>} Sales) for the previous month.

[#3]

i want to know how to calculate sales for selected month,if i give expression sum of sales

it will show sales for 12 months in chart.

[masha-ecraft · Accepted solution]

If you have only one month selected then sum(Sales) shows sales for that selected month. If nothing is selected then Sum(Sales) is your total sales.

[nilesh_gangurde]

Hi shantanu,

If possible Please attach the sample data with qvw file.

Regards,

Nilesh Gangurde

[#6]

sum({<Month=Month-1>} Sales)

this code not working gives same value as selected mont

could u please check it