Straight Table Total

[qlikview979]

Hi Experts,

please find the attached file

I have one requirement  my data is like

Desc	Country	Revenue	Adjust
AB	IND	0	100
BC	IND	200	0
CA	IND	300	950
DE	PAK	0	450
EF	PAK	500	550
FG	PAK	600	0
LM	SL	0	250
MN	SL	800	0
OP	SL	900	150

Here  total revenue is (3300) and total Adjust is(2450)

i have created one straight table and

Dim:- Desc

Exp:-Sum(Revenue) like below

Desc	Revenue
3300
BC	200
CA	300
EF	500
FG	600
MN	800
OP	900

in this straight table i have to add one row  in this table     it is TOTALADJUSR   in Dimension column and sum(Adjust) in Expression row.

how can i achieve this.

Final out put table is

Desc	Revenue
3300
BC	200
CA	300
EF	500
FG	600
MN	800
OP	900
Totaladjust	2450

Regards

mahesh

[qlikview979]

Hi Experts help me on this

stalwar1‌kush141087‌dvqlikview‌avinashelite‌

Regards,

Mahesh

[sunny_talwar · Accepted solution]

Check attached

[qlikview979]

Thanks bro

   

Regards,

mahesh