expression in column

[AlanM]

Hello All,

I have an issue with the following topic and hope to find a solution.

I have a report with the following measures and dimensions:

Actual:

	act. Month	Expression
Umsatz IST	100 €	Sum({$<[Datenart]={'IST'}>}[Umsatz])
Umsatz PLAN	80 €	Sum({$<[Datenart]={'PLAN'}>}[Umsatz])
Umsatz Abw.	20 €	Sum({$<[Datenart]={'IST'}>}[Umsatz]) - Sum({$<[Datenart]={'PLAN'}>}[Umsatz])
Umsatz Abw. %	20 %	(Sum({$<[Datenart]={'IST'}>}[Umsatz]) - Sum({$<[Datenart]={'PLAN'}>}[Umsatz]))/Sum({$<[Datenart]={'IST'}>}[Umsatz])
Kosten IST	80 €	Sum({$<[Datenart]={'IST'}>}[Kosten])
Kosten PLAN	70 €	Sum({$<[Datenart]={'PLAN'}>}[Kosten])
Kosten Abw.	10 €	Sum({$<[Datenart]={'IST'}>}[Kosten]) - Sum({$<[Datenart]={'PLAN'}>}[Kosten])
Kosten Abw. %	20 %	(Sum({$<[Datenart]={'IST'}>}[Kosten]) - Sum({$<[Datenart]={'PLAN'}>}[Kosten]))/Sum({$<[Datenart]={'IST'}>}[Kosten])

Attached .png shows the actual table in Qlik.

Values for „IST“ and „PLAN“ already exist.

Goal:

The goal is to have the following structure of the report:

	IST	PLAN	Abw.	Abw. %
Umsatz	100 €	80 €	?	?
Kosten	80 €	70 €	?	?

„Datenart“ is a dimension that should simply be dragged into the column.

„Abw.“ & Abw. %“ should be able to be filled with an expression.

Does anybody have an idea how to solve that?

Thanks in advance.

[JonasValleskog]

Hi Alan,

Just a gentle nudge that something probably went wrong in posting the question as your target structure isn't visible (at least not to me).

Regards

Jonas

[AlanM]

 Thanks for the reply @JonasValleskog 

now a new attempt to better describe the target structure.

The goal is to have the following structure of the report:

	Column A	Column B	Column A - Column B	(Column A - Column B) /Column A
Datenart	IST	PLAN	Abw.	Abw. %
Umsatz	100 €	80 €	20	20
Kosten	80 €	70 €	10	12,5

„Datenart“ is a dimension that should simply be dragged into the column.

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

Column A - Column B

"Abw. %“ should be able to be filled with an expression like:

(Column A - Column B) / Column A

it is possible to subtract columns from each other?

If not, any other ideas?

Thanks in advance.