Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a straight table where I have Year-Month,Business Area (A,B,C,D) as my dimensions and I have a expression Sales MAT(MAT-Moving Annual total).In this chart I am showing the latest 3years of data.Lets say we are in May 2013.. so the chart would contain data from May 2013 to Jul 2010 (36months of data).so If I want to see the sales for April 2013. then we sum up all the sales from Apr 2013 to May 2012 ( 1year back) .Attaching the sample data for ur reference.
For Apr 2013 the sales should come as 75,309 by summing all the previous 12months of data.for this I have selected the option of accumulation in the chart as
Accumulation =12 .but it is not working.
The sales value showing for individual Month -Year and Business area combination (Row wise) data is corect but the chart is failing to accumulate the data.
Any suggestions about this please??
Thanks in advance.
Accumulation doesn't work if you have more than one dimension afaik. See this document for an alternative approach.