Subtract value from one row to another row in QLIK SENSE ( Straight table )

[rajaiqliksense]

Hello friends,

Anybody there to help urgently.

I have a requirement in P&L where need to calculate consolidation and i'm unable to calculate the

consolidated EBITA (i.e Adjustment figure have to be subtracted after summing up rev and expense from all companies

to derive consolidated EBITA)

I've adjustment value comes in the format of  [COMP1, COMP2, 'REVENUE' ACC_GRP, ADJUSTAMENT VALUE{10}],

[comp1,comp2,'expense' acc_grp, adjustment value {20}]

how could i apply adjustment value for EBITA calculation

I used this formula for adding adjustment figure of expense with ebita but failed to achieve

sum(TOTAL (AGGR(
(IF(MATCH(CON_VW, $(Vconcat)),sum(ADJ),0))

,CON_VW)))

here CON_VW -> COMP1, COMP2

AND Vconcat result would be COMP1,COMP2

COMP1			COMP2			CONSOLIDATED VALUE	ADJUSTMENT	final	TOTAL
REV	100		REV	100		200	-10	REV	190
EXP	80		EXP	20		100	-20	EXP	80
EBITA	20		EBITA	80		100		EBITA(output)	110

I tried things in pivot, and working on straight table after pivot failure

Please kindly help n this, as its very urgent

Thanks & Regards

Raja

[OmarBenSalem]

Can please simplify what u're aiming to do?

example of how to present:

What I have

What I want to achieve; with some data (3 to 4 lines)

Thanks

I won't lie to u, I did not understand a thing..

[dplr-rn]

Think you may need to use value list
https://community.qlik.com/t5/Qlik-Design-Blog/ValueList-For-those-tricky-situations/ba-p/1476275