Pivot Table Total

[upaliwije]

Hi

I have below pivot table in my QV document.

	BUSINESS_TYPE	NEW_BUSI.	RENEWALS	Total
DEPT	BUSINESS_SOURCES
CITY	FIN_INSTITUTE	7,886,294	11,967,726	19,854,020
CITY	BROKERS	2,528,363	3,429,568	5,957,931
CITY	BANKS	2,251,519	1,744,495	3,996,014
CITY	Total	12,666,176	17,141,789	29,807,965
HEAD	FIN_INSTITUTE	11,516,923	17,018,929	28,535,852
HEAD	BROKERS	2,262,000	6,244,468	8,506,469
HEAD	BANKS	1,084,472	444,017	1,528,489
HEAD	Total	14,863,395	23,707,414	38,570,809
REGION	FIN_INSTITUTE	8,218,136	7,109,669	15,327,806
REGION	BROKERS	1,392,852	2,537,745	3,930,597
REGION	BANKS	734,781	623,696	1,358,476
REGION	Total	10,345,769	10,271,110	20,616,878
TOTAL	FIN_INSTITUTE	12,666,176	17,141,789	29,807,965
TOTAL	BROKERS	17,446,058	22,315,852	39,761,910
TOTAL	BANKS	26,434,619	35,905,212	62,339,831
TOTAL	Total	26,445,099	40,405,186	66,850,286

But I am unable obtain the total marked in red from the QV pivot table it self. Pls some one help me how to extract figures shown in red.

[#2]

enable partial sums for BUSINESS_SOURCES in presentation tab

[Digvijay_Singh]

I think options provided in below solution will help you to achieve something like you want -

Re: Sum and Count at the bottom of the same table.

Credited to  sunindia‌, jagan‌

[upaliwije]

Can some give me an idea of how to do what I want