Problem with Straight Table Totals

[munna1317]

Hi all ,

Below is Straight table , Actually the total Should Below Blue Mark , But It is Coming in Red Color Total .

What is problem in this Straight Table

REGION	COUNTRY	BUSINESS	LENSBRAND	Net Sales
				156055
ASIA	H	L	H	29257
ASIA	H	L	L	13033
ASIA	H	L	O	15881
ASIA	H	L	P	90
ASIA	H	L	S	1114
ASIA	H	L	V	815
ASIA	H	L	-	96353
			Total	156543

Please help me out of this .

Thanks in advance ,

Harish

[Anil_Babu_Samineni]

I didn't face any issue here, Use simple sum([Net Sales])

[sushil353 · Accepted solution]

Hi,

In the expression tab > Total Mode > check for Sum of Rows

HTH

Sushil

[munna1317]

Yes Got it Sushil Thanks for Immediate Replay

[Anil_Babu_Samineni]

Sushil, But Qlik Staight object took me direct. Why do we need to change again. Just for clarification