Previous Year to selected year month wise results in straight table

[#1]

Hi Team,

I have my data:

load * Inline [

Year, Month, Sales

2012,1,1000

2012,2,2000

2012,3,3000

2012,4,1000

2012,5,1000

2012,6,1000

2012,7,1000

2013,1,1000

2013,2,1000

2013,3,1000

2013,4,1000

2013,5,1000

2013,6,1000

];

I have two listboxes for Year and Month. When user selects 2013 and month 6, I want to display the details from 2012 month 6 to 2013 month 5 in a straight table.

Can you please help. I am unable to attach a sample qvw file

[maxgro]

add a field to your table

Z:

load *, 12*(Year(Today())-Year) + Month(Today()) - Month as MonthsAgo

Inline [

Year, Month, Sales

2012,1,1000

2012,2,2000

2012,3,3000

2012,4,1000

2012,5,1000

2012,6,1000

2012,7,1000

2013,1,1000

2013,2,1000

2013,3,1000

2013,4,1000

2013,5,1000

2013,6,1000

];

in your chart use the expression (dimensions are Year and Month)

sum({$ <Year=,Month=,MonthsAgo={">=$(=max(MonthsAgo)+1)<=$(=max(MonthsAgo)+12)"}> } Sales)

[#3]

Cant we do it without creating an extra field?

Thanks for the quick response

[maxgro]

maybe with an or in set analysis

max year and month < max month

+

max year -1 and month >= max month 

[tamilarasu · Accepted solution]

Hi S V,

Try below expression,

sum({<Month = {"<=$(=Month-1)"},Year={"$(=Year)"}>}Sales)

+ sum({<Month = {">=$(=Month-1)"},Year={"$(=Year-1)"}>}Sales)

File attached against your data. Let me know.

[#6]

Thanks alot for the help. It resolved my issue