R
rashpal.sidhu
Ive added a calculated field to a pivot table to get a very basic
percentage, one field divided by another. This works fine, however
when i try adding a subtotal for one of the columns the calculated
filed is missing. All of the other subtotals appear. (Indicated by ???
in below extract, this may not show up properly depending on tabs).
Anybody come accross this before and can anyone help please?
Dec Grand Total
Plano Low High Plano SumLow Sum High Sum
712 1,405 69 11,112 22,617 1,057 34,786
20 19 10 157 286 159 602
2.81% 1.35% 14.49% ??? ??? ??? 1.73%
16 17 8 119 230 123 472
2.25% 1.21% 11.59% ??? ??? ??? 1.36%
£28,383 £60,836 £5,658 £435,843 £989,650 £98,324 £1,523,817
469 925 29 7,022 14,698 465 22,185
4 8 8 55 193 53 301
0.85% 0.86% 27.59% 1.36%
2 7 9 38 174 56 268
0.43% 0.76% 31.03% 1.21%
£29,300 £66,829 £5,649 £432,680 £985,160 £80,151 £1,497,990
percentage, one field divided by another. This works fine, however
when i try adding a subtotal for one of the columns the calculated
filed is missing. All of the other subtotals appear. (Indicated by ???
in below extract, this may not show up properly depending on tabs).
Anybody come accross this before and can anyone help please?
Dec Grand Total
Plano Low High Plano SumLow Sum High Sum
712 1,405 69 11,112 22,617 1,057 34,786
20 19 10 157 286 159 602
2.81% 1.35% 14.49% ??? ??? ??? 1.73%
16 17 8 119 230 123 472
2.25% 1.21% 11.59% ??? ??? ??? 1.36%
£28,383 £60,836 £5,658 £435,843 £989,650 £98,324 £1,523,817
469 925 29 7,022 14,698 465 22,185
4 8 8 55 193 53 301
0.85% 0.86% 27.59% 1.36%
2 7 9 38 174 56 268
0.43% 0.76% 31.03% 1.21%
£29,300 £66,829 £5,649 £432,680 £985,160 £80,151 £1,497,990