Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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]))
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]))