How do I add calculated items to a pivot table

[#1]

I have the following pivot table

Type Amount

Income 100

Costs 20

Expenses 50

I want Qlikview to add a row called "Gross profit" being Income less Costs below Costs.

How do I do that?

Louis Kruger

[Anonymous]

Add an Expression called 'Gross profit':

([Income] - [ Costs]) / [Costs]

Just make an calculated expression which does the calculation you request.

Anita

[#3]

Anita, thank you for your response.

I have added Gross profit to expression label and ([Income] - [Costs]) to the definition window.

and what I get is

Type

Income sum(Amount) 100

Gross profit -

Costs sum(Amount) 20

Gross profit -

Expenses sum(Amount) 50

Gross profit -

and what I want is

Type

Income 100

Costs 20

Gross profit 80

Expenses 50

where do I go wrong?

[Anonymous]

Are Income, Costs, Expenses dimensions?

Or are they part of dimension 'Type'??

[#5]

They are part of Type