Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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:
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.
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
)
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: