Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Look into below link... ..
Sum Sales for previous 12 months
Rolling 12 Month Sales using Set Analysis Chart Sort?
Or provide sample data to work..
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