set analysis previous year but in one dimension point

[#1]

Hello,

i have a table with columns yearMonth and amount

for example

201401 - 20

201402 - 10

201403 - 10

201501 - 10

201501 - 10

201502 - 10

201503 - 10

what i would like to do is when i select only one yearMonth, for example 201501, i want to see the sum of previous year (201401) on the same dimension point = 201501. i do not want a 201401 point created on the  x axis.

I have 1 dimension = yearMonth and 2 expressions

=sum(amount)

=sum(expression-where-year-1 amount)

But the graph shows x points 201401 and 201501 but i want the sum of amount 201401 be shown on point 201501, next to sum of amount 201501 if you know what i mean?

- with full accumulation, the sum amount 201401 is shown on 201501 point but the 201401 point also stays visible

- using the expression as a variable works fine, but only when selecting one month. When selecting more months, it shows the same sum of amount for all months, because the variable is static.

Thanks

[#2]

Hi,

I think no need to add 2nd expression. In Presentation tab, Text in Chart section, add the 2nd expression mentioned in your question. Thereby you can create a label which displays the cumulative sum.

Hope this helps.

Regards

NGS