6 Months Trend in Bar Chart

[#1]

Hi Team,

Need your help in creating barchart which should show last 6 months data.

below are the columns

Regions      CalendarMonth      Sales

Canada        JAN2014               ***

Canada        FEB2014               -----

Canada        MAR2014              ****

--------------- and so on till DEC2014

USA           JAN2014               ****

USA           FEB2014               ------

USA           MAR2014               ****

--------------- and so on till DEC2014

Please help me with expression which gives me last 6 months sales with respect to region.

Thanks,

Rakesh.

[Siva_Sankar]

Rakesh,

Find the attached working example with your data. Ctreate a variable to compute last 6 months and use it in set analysis with your expression. Created a line chart also, good one for showing trend.

[#3]

Hi,

It will help u to complete u r task

in dimensions : regions

in Expressions: sum({<CalendarMonth = {JAN2015,FEB2015,MAR2015,APR2015,MAY2015,JUN2015}>} sales)

Hope it will help u.

Thanks and regards

Balaji.k

[krishna20]

Hi,

try this,

=sum({<CalendarMonth   ={"<=$(=(AddMonths(Max(CalendarMonth),-6)))"}>}Sales)