Column Total for each row

[Anonymous]

I have the following data

PID	CustomerID	Country	Qty	Amount
1	ALFKI	India	10	1000
2	ANATR	India	20	2000
3	BERGS	India	30	3000
4	ALFKI	USA	15	15000
5	ANATR	USA	25	25000
6	BERGS	USA	35	35000
7	ANATR	UK	20	200000
8	BERGS	UK	40	400000
9	ALFKI	UK	60	600000
10	AROUT	Japan	100	100000

I have created the pivot table in qlikview.

I want the "Sum of Count PID" and "Sum of Amount" to be displayed. (for below I have created it manually)

Please suggest.

CustomerID	ALFKI	ALFKI	ANATR	ANATR	AROUT	AROUT	BERGS	BERGS	Sum of Count PID	Sum of Amount
Country	Count PID	Amount	Count PID	Amount	Count PID	Amount	Count PID	Amount	Sum of Count PID	Sum of Amount
India	1	1000	1	2000	-	-	1	3000	3	6000
Japan	-	-	-	-	1	100000	-	-	1	100000
UK	1	600000	1	200000	-	-	1	400000	3	1200000
USA	1	15000	1	25000	-	-	1	35000	3	75000

[sunny_talwar]

Did you try to enable 'show partial sums' on the presentation tab of chart properties?

[devarasu07]

Hi,

Try to create pivot chart object

Dimension:

Country

CustomerID

Measure:

Count

Count(DISTINCT PID)

Amount:

sum(Amount)

go to chart property--> presentation tab--> enable "Always fully expanded"

and "Show Partial Sums" check box then you will get the desired output.

Thanks

Deva

[sunny_talwar]

devarasu07‌, Why is 'Always fully expanded' needed here? Did I miss the part of the question above?

[devarasu07]

Hi Sunny,

It's not required actually, because of two dimension expanded it (this case not required, one dimension sitting in row and other one sitting in column.)

Thanks,
Deva

[sunny_talwar]

Oh okay, I saw that part in your response and I wondered that did I miss something in the question. Thanks for getting back with the explanation

[Anonymous]

Thanks for your reply.

Is there any way to show a common header "CustomerID" above customer id values (ALKFI,ANTAR,AROUT,BERGS).

Currently it is displayed on left Side.

Please Suggest