Dimension targeting an other dimension value

[#1]

Hi,

I don't understand how I can get rid of that.

This is what I have:

I want the value of "Result previous month" pointing on the result of the previous month. If Jan, 0.

The months are stings values, not dates, but we can eventually work with months as dates.

Thanks for your help.

Best regards,

A

[Gysbert_Wassenaar · Accepted solution]

Try =Above(result)

[#3]

Haha didn't know about "table functions".

[#4]

I have an other issue. If I do that, I can reuse this value in the pivot table as a new expression like:

• I create a new expression
• I write: (Result previous month)/2, it works

But how can I reuse this value outside the pivot table ? I need that value as an offset in a chart.