subtract columns dimension

[AlanM]

Hello Guys,

the goal is to show the difference between column "Actual." and "Budget" in column "Diff." (See table):

Datatype	Actual	Budget	Diff.
Measure 1	100 €	80 €	20
Measure 2	80 €	70 €	10

Column „Diff.“ should be able to be filled with an expression like:

Column A - Column B

The measures must be in the rows.

Problem: "Datatype" is a dimension with only two characteristics "Actual" and "Budget"

Any ideas?

Thanks in advance.

[AlanM]

Hello Guys,

the goal is to show the difference between column "Actual." and "Budget" in column "Diff." (See table):

Datatype	Actual	Budget	Diff.
Measure 1	100 €	80 €	20
Measure 2	80 €	70 €	10

Column „Diff.“ should be able to be filled with an expression like:

Column A - Column B

The measures must be in the rows.

Problem: "Datatype" is a dimension with only two characteristics "Actual" and "Budget"

Any ideas?

Thanks in advance.

[AlanM]

Hello Guys,

the goal is to show the difference between column "Actual." and "Budget" in column "Diff." (See table):

Datatype	Actual	Budget	Diff.
Measure 1	100 €	80 €	20
Measure 2	80 €	70 €	10

Column „Diff.“ should be able to be filled with an expression like:

Column A - Column B

The measures must be in the rows.

Problem: "Datatype" is a dimension with only two characteristics "Actual" and "Budget"

Any ideas?

Thanks in advance.

[jonathandienst]

Did you try 

=Column(1) - Column(2)

[AlanM]

Thanks for the fast reply.

Yes I did.

I need the expression Column (1)- Column (2) as a row next to "Plan-Daten"

is this possible?