How to Achieve this

[alvinford]

Hi ,

Request your help to achieve this.

I have the sales from Jan 2013 till 2015 Feb. Want to display the current sales and carried over sales in the Bar Chart with Dimension as Country.

if I am selecting the  Year = 2015  and Month =Feb, My current sales should the sales for 2015 Feb and my carried over sales should be

from Jan 2013 till 2015 Jan

and in the same way if I am selecting the Year = 2014 and Month = Aug,My current sales should the sales for 2014 Aug

and my carried over sales should be from Jan 2013 till 2014 Jul.

How to achieve this using set analysis.

Regards,
Alvin.

[MK_QSL]

Look into below link... ..

YTQ, QTD, MTD and WTD

Sum Sales for previous 12 months

Rolling 12 Month Sales using Set Analysis Chart Sort?

Or provide sample data to work..

[petter]

Current Sales:    Sum( Sales )

Carried over Sales:  Sum(  {<YearMonth={"<=$(=Max(YearMonth))"},Year=,Month=>} Sales )

The Year and Month has to be deselected (in blue above) as they would otherwise interfer with the selection of YearMonth.

Create a field in your load script like this:

    Year( thisDate )*100 + Num( Month( thisDate ) )  AS YearMonth