Show accumulated values for certain time period

[Cam_Ly]

Hi,

I want to show accumulated values for the last twelve months.

Here I have a table which gives me the turnover per period. Unfortunately it gives me all the historic data I have (starting March 2000).

To show the marked dimensions, I tried with a second calendar-table with only the last twelve months, but as I use it in a SetAnalysis-Expression I miss the accumulation. 

The expression:

sum({<Periode_SalesTable=P(Periode_CalendarTable)>}turnover_EUR)/1000000

The graph:

How can I show the last twelve months without losing the accumulation?

Thanks for any help!

[Cam_Ly]

Found a solution in the Measure-Expession:

If(Sum({<Periode_Sales=P(Periode)>}Turnover_EUR) <> 0,
(
Sum(Turnover_EUR) +
Above(Sum(Turnover_EUR), 1) +
Above(Sum(Turnover_EUR), 2) +
Above(Sum(Turnover_EUR), 3) +
Above(Sum(Turnover_EUR), 4) +
Above(Sum(Turnover_EUR), 5) +
Above(Sum(Turnover_EUR), 6) +
Above(Sum(Turnover_EUR), 7) +
Above(Sum(Turnover_EUR), 😎 +
Above(Sum(Turnover_EUR), 9) +
Above(Sum(Turnover_EUR), 10) +
Above(Sum(Turnover_EUR), 11)
) / 1000000)

After that I suppress zero values. But now I face another issue, because I don't see the current month, as there are no turnover data.

[Chanty4u]

Try this 

If(

  Sum({<Periode_Sales=P(Periode)>} Turnover_EUR) <> 0 or Sum(Turnover_EUR) = 0,

  (

    Sum(Turnover_EUR) +

    Above(Sum(Turnover_EUR), 1) +

    Above(Sum(Turnover_EUR), 2) +

    Above(Sum(Turnover_EUR), 3) +

    Above(Sum(Turnover_EUR), 4) +

    Above(Sum(Turnover_EUR), 5) +

    Above(Sum(Turnover_EUR), 6) +

    Above(Sum(Turnover_EUR), 7) +

    Above(Sum(Turnover_EUR), 😎 +

    Above(Sum(Turnover_EUR), 9) +

    Above(Sum(Turnover_EUR), 10) +

    Above(Sum(Turnover_EUR), 11)

  ) / 1000000

)

[Cam_Ly · Accepted solution]

Thanks! Your expression gives me the right hint!

The solution:

If(

Sum({<Periode_Sales=P(Periode)>} Turnover_EUR) <> 0 or IsNull(Periode_Sales),

(

Sum(Turnover_EUR) +

Above(Sum(Turnover_EUR), 1) +

Above(Sum(Turnover_EUR), 2) +

Above(Sum(Turnover_EUR), 3) +

Above(Sum(Turnover_EUR), 4) +

Above(Sum(Turnover_EUR), 5) +

Above(Sum(Turnover_EUR), 6) +

Above(Sum(Turnover_EUR), 7) +

Above(Sum(Turnover_EUR), 😎 +

Above(Sum(Turnover_EUR), 9) +

Above(Sum(Turnover_EUR), 10) +

Above(Sum(Turnover_EUR), 11)

) / 1000000,
)

The result: