Fix column in a diagramm sum table

[#1]

Hello together,

i have problems with a Diagramm Table Sum.

In the following you see the filtes of the table:

Year
2014
2013

Nature
Actual
Forecast I
Forecast II
Last year

Month	Month	Month	Month
1	2	3	4
5	6	7	8
9	10	11	12

Here you see the Diagramm Tabel Sum

	Actual	Forecast	Last Year
Revenue	it should Show always the actual figures (filter of	it should choicable for the Forecast I oder II	it should Show always  the last year filter
Forecast	it works
Gross Margin

I Need help of the columns. The first colum works, if I click a other filter (eg. Forecast 1) it Shows the actual. But in the second column it Shows me the choicable Filter (eg. last year, forecast I or forecast II).

How can I fix the forecast column to Show me only forecast I or forecast II?

How can I fix the Last year column, that it Shows me always the Last Year Filter.

Does anyone can help me.

Thanks.

Jörn

[Gysbert_Wassenaar]

Actual: sum({<Nature={'Actual'}>}Value)

Forecast: sum({<Nature={'$(=only(Nature))'}*{'For*'}>}Value)

Last Year: sum({<Nature={'Last Year'}>}Value)

[#3]

Thank you for this quick Response.

How I get this three formulas in the Formula field

Do I Need a Conditional in the field.

Thank you.

[Gysbert_Wassenaar · Accepted solution]

See attached example.