Ho w to show value as % of total row

[Anonymous]

Hi,

I would like to add in a pivot table the share % of total value of row (partial sums)

I am using personal edition.

This is my data, I want to show 152,528/224,576 in a new column.

Territory	Ageing	1) 0 to 3 Months	2) 4 to 6 Months	3) 7 to 9 Months	4) 10 to 12 Months	5) 13 to 18 Months	6) 19 to 24 Months	7) Above 24 Months	Total
A		152,528	47,644	8,026	7,150	7,826	1,118	284	224,576
B		252,249	72,267	15,776	27,170	35,924	9,868	4,040	417,294
C		330,927	93,158	16,034	38,907	24,281	6,965	4,636	514,907
D		255,490	98,024	10,689	11,676	20,999	3,847	2,431	403,156
E		55,736	19,574	2,986	4,739	8,668	1,456	1,056	94,215
F		202,561	113,160	6,003	6,547	13,847	2,624	1,587	346,328
G		300,573	41,126	1,118	12,352	16,556	2,424	1,618	375,767
H		578,569	140,796	22,037	56,990	45,221	12,628	7,328	863,569
I		1,284,712	274,893	94,999	76,610	100,007	8,892	4,968	1,845,080
Total		3,413,343	900,643	177,669	242,141	273,329	49,820	27,947	5,084,891

I know it can be done as sum(stock)/sum(total stock). But my problem is that my stock field is very complicated:

=sum(SOH_Quantities)+sum([In Transit Quantity])-sum([DMG Quantity])-sum([Pending COD Quantity Cumulative])

Thanks,

Lea

[sunny_talwar · Accepted solution]

May be this

=(Sum(SOH_Quantities)+Sum([In Transit Quantity])-Sum([DMG Quantity])-Sum([Pending COD Quantity Cumulative]))/(Sum(TOTAL <Territory> SOH_Quantities)+Sum(TOTAL <Territory>[In Transit Quantity])-Sum(TOTAL <Territory>[DMG Quantity])-Sum(TOTAL <Territory> [Pending COD Quantity Cumulative]))