Spreadsheet: 190287d1351607394-how-pivot-table-showing-divide-from-accumulate-value-book2
Sheet: Trend Data

Project | type | sub type | Period | value | % | value x % | value / % | accumulate (value) | accumulate (value x %)
item 1 | type 2 | sub 2 | January | 1.112313551420328 | 0 | 0 | 0 | 1.112313551420328 | 0
item 2 | type 3 | sub 1 | January | 22.063536 | -0.0850605296069597 | -1.876736057162221 | -259.386299402899 | 23.17584955142033 | -1.876736057162221
item 3 | type 5 | sub 1 | January | 6.26334689 | -0.1411671948722572 | -0.8841791109731761 | -44.36828893332994 | 29.43919644142033 | -2.760915168135397
item 4 | type 5 | sub 2 | January | 8.01557814 | -0.8640265709732896 | -6.925672494672659 | -9.277004214084283 | 37.45477458142033 | -9.686587662808057
item 5 | type 4 | sub 1 | January | 14.31092 | 0.0415632754342431 | 0.5948087096774182 | 344.3164632835827 | 51.76569458142033 | -9.091778953130639
item 6 | type 3 | sub 1 | January | 48.9 | -0.1944909823584478 | -9.510609037328097 | -251.4255386395091 | 100.6656945814203 | -18.60238799045874
item 7 | type 4 | sub 2 | January | 0 | 0 | 0 | 0 | 100.6656945814203 | -18.60238799045874
item 8 | type 1 | sub 2 | January | 202.13116 | 0.1761153054221002 | 35.59839097872339 | 1147.720577240842 | 302.7968545814203 | 16.99600298826466
item 9 | type 4 | sub 1 | January | 14.64964 | 0.1243327396814312 | 1.821429876546682 | 117.826085370078 | 317.4464945814203 | 18.81743286481134
item 10 | type 4 | sub 2 | January | 1.26821575 | 0.06404380545810356 | 0.08122136277190291 | 19.80231719412187 | 318.7147103314203 | 18.89865422758324
item 11 | type 4 | sub 1 | January | 0 | 0 | 0 | 0 | 318.7147103314203 | 18.89865422758324
item 12 | type 5 | sub 1 | January | 20.8935 | 0.1355345911949684 | 2.831791981132073 | 154.1562180974479 | 339.6082103314204 | 21.73044620871531
item 13 | type 3 | sub 1 | January | 0 | -0.4822485207100592 | 0 | 0 | 339.6082103314204 | 21.73044620871531
item 14 | type 4 | sub 1 | January | 3.0417056 | 0.008027231332969535 | 0.0244164744979889 | 378.923376420843 | 342.6499159314204 | 21.7548626832133
item 15 | type 4 | sub 2 | January | 0 | 0 | 0 | 0 | 342.6499159314204 | 21.7548626832133
item 16 | type 4 | sub 1 | January | 3.9 | -0.1097791421123783 | -0.4281386542382752 | -35.525874268608 | 346.5499159314203 | 21.32672402897503
item 17 | type 4 | sub 1 | January | 3.696 | -0.1523853193605618 | -0.5632161403566365 | -24.25430491276409 | 350.2459159314204 | 20.76350788861839
item 18 | type 4 | sub 2 | January | 0 | 0 | 0 | 0 | 350.2459159314204 | 20.76350788861839
item 19 | type 4 | sub 1 | January | 3 | -0.1018311629913094 | -0.3054934889739283 | -29.46052968339396 | 353.2459159314204 | 20.45801439964446
item 20 | type 4 | sub 1 | January | 0 | 0 | 0 | 0 | 353.2459159314204 | 20.45801439964446
item 21 | type 4 | sub 1 | January | 20.34941138146 | 0.02169744907251275 | 0.4415303171048397 | 937.8711439050912 | 373.5953273128804 | 20.8995447167493
item 22 | type 4 | sub 2 | January | 29.106356045592 | -0.04558528462194877 | -1.326821524646091 | -638.5033303395813 | 402.7016833584724 | 19.57272319210321
item 23 | type 2 | sub 1 | January | 0 | -0.1760566678374897 | 0 | 0 | 402.7016833584724 | 19.57272319210321
item 24 | type 4 | sub 2 | January | 45.81188 | -0.07730845610976272 | -3.541645714285717 | -592.5856278251914 | 448.5135633584724 | 16.03107747781749
item 25 | type 4 | sub 1 | January | 5.9452185 | -0.2037053464857801 | -1.21107279447617 | -29.18538272344763 | 454.4587818584724 | 14.82000468334132
item 26 | type 3 | sub 1 | January | 18.80415 | -0.283068783068783 | -5.322867857142855 | -66.42961401869161 | 473.2629318584724 | 9.497136826198469
item 27 | type 3 | sub 1 | January | 16.01835 | -0.3896659580518057 | -6.241805699159142 | -41.10790195809297 | 489.2812818584724 | 3.255331127039327
item 28 | type 5 | sub 2 | January | 12.32 | -0.2076795839059329 | -2.558612473721093 | -59.32215275229107 | 501.6012818584724 | 0.6967186533182348
item 29 | type 4 | sub 1 | January | 4.711007 | -1.48057576628166 | -6.975002798983265 | -3.18187498896547 | 506.3122888584724 | -6.27828414566503
item 30 | type 4 | sub 2 | January | 1.973565 | -3.154924907063197 | -6.226449374208179 | -0.6255505465697815 | 508.2858538584724 | -12.50473351987321
item 31 | type 5 | sub 2 | January | 0 | 0 | 0 | 0 | 508.2858538584724 | -12.50473351987321
item 32 | type 5 | sub 2 | January | 0 | 0 | 0 | 0 | 508.2858538584724 | -12.50473351987321
item 33 | type 4 | sub 1 | January | 77.22816 | 0.05525589654054647 | 4.267311218976769 | 1397.645587803112 | 585.5140138584725 | -8.23742230089644
item 34 | type 1 | sub 2 | January | 157.67416 | -0.05567657412561644 | -8.778757056934307 | -2831.965911628444 | 743.1881738584725 | -17.01617935783075
item 35 | type 5 | sub 2 | January | 0 | 0 | 0 | 0 | 743.1881738584725 | -17.01617935783075
item 36 | type 5 | sub 1 | January | 0 | 0.2428571428571429 | 0 | 0 | 743.1881738584725 | -17.01617935783075
item 37 | type 4 | sub 1 | January | 0 | 0.4421095367605167 | 0 | 0 | 743.1881738584725 | -17.01617935783075
item 38 | type 5 | sub 2 | January | 43.1799 | 0.06915598762704384 | 2.98614863013699 | 624.3841130990407 | 786.3680738584725 | -14.03003072769376
item 39 | type 5 | sub 2 | January | 22.2864 | 0.01803528886241818 | 0.4019416617033964 | 1235.71073188854 | 808.6544738584724 | -13.62808906599036
item 40 | type 5 | sub 2 | January | 0 | 0.2989810097267253 | 0 | 0 | 808.6544738584724 | -13.62808906599036
item 41 | type 3 | sub 2 | January | 7.2 | -1.170634920634921 | -8.428571428571429 | -6.150508474576271 | 815.8544738584725 | -22.05666049456179
item 42 | type 3 | sub 1 | January | 13.929 | -1.854529411764706 | -25.83174017647059 | -7.510800266438292 | 829.7834738584725 | -47.88840067103237
item 43 | type 5 | sub 2 | January | 26.4651 | -0.2506664635539645 | -6.633913024602026 | -105.5789419325433 | 856.2485738584725 | -54.5223136956344
item 44 | type 2 | sub 2 | January | 0 | 0 | 0 | 0 | 856.2485738584725 | -54.5223136956344
item 45 | type 2 | sub 2 | January | 0 | 0 | 0 | 0 | 856.2485738584725 | -54.5223136956344
item 46 | type 2 | sub 2 | January | 0 | 0 | 0 | 0 | 856.2485738584725 | -54.5223136956344
item 47 | type 2 | sub 2 | January | 0 | 0 | 0 | 0 | 856.2485738584725 | -54.5223136956344
item 48 | type 3 | sub 2 | January | 26.4651 | -0.242372340116701 | -6.414408218422504 | -109.1919151634926 | 882.7136738584725 | -60.9367219140569
item 49 | type 4 | sub 2 | January | 0 | 0 | 0 | 0 | 882.7136738584725 | -60.9367219140569
item 50 | type 4 | sub 1 | January | 14.7438465 | -0.1016428878259368 | -1.498607135922331 | -145.0553680179651 | 897.4575203584725 | -62.43532904997922
item 51 | type 4 | sub 1 | January | 0 | 0 | 0 | 0 | 897.4575203584725 | -62.43532904997922
item 52 | type 4 | sub 2 | January | 1.31310417 | 0.001075554257819578 | 0.001412314781004142 | 1220.862788142363 | 898.7706245284725 | -62.43391673519822
item 53 | type 4 | sub 1 | January | 0 | 0 | 0 | 0 | 898.7706245284725 | -62.43391673519822
item 54 | type 5 | sub 1 | January | 6.81 | -0.1721436654379751 | -1.17229836163261 | -39.55998022159987 | 905.5806245284724 | -63.60621509683083
item 55 | type 4 | sub 2 | January | 0 | 0 | 0 | 0 | 905.5806245284724 | -63.60621509683083
item 56 | type 5 | sub 1 | January | 0.8 | -0.7473034477084813 | -0.5978427581667851 | -1.070515601731942 | 906.3806245284724 | -64.20405785499761
item 57 | type 4 | sub 1 | January | 8.427045 | 0 | 0 | 0 | 914.8076695284724 | -64.20405785499761
item 58 | type 5 | sub 2 | January | 0 | -0.2600000000000001 | 0 | 0 | 914.8076695284724 | -64.20405785499761
item 59 | type 4 | sub 1 | January | 2.384293667447182 | 0 | 0 | 0 | 917.1919631959196 | -64.20405785499761
item 60 | type 5 | sub 1 | January | 11.1432 | 0.03749851707128998 | 0.4178534754287985 | 297.163751270889 | 928.3351631959196 | -63.78620437956882
item 61 | type 1 | sub 2 | January | 2.03232 | 0.1401515151515151 | 0.2848327272727272 | 14.50087783783784 | 930.3674831959196 | -63.50137165229609
item 62 | type 4 | sub 1 | January | 0 | -0.1344852673699527 | 0 | 0 | 930.3674831959196 | -63.50137165229609
item 63 | type 5 | sub 1 | January | 2.2 | -0.06408179793480448 | -0.1409799554565699 | -34.33112164297006 | 932.5674831959196 | -63.64235160775266
item 64 | type 4 | sub 1 | January | 2.61999 | -0.5059610303487644 | -1.325612839903459 | -5.178244652940984 | 935.1874731959197 | -64.96796444765612
item 65 | type 4 | sub 2 | January | 0.8 | -0.2261904761904762 | -0.180952380952381 | -3.536842105263158 | 935.9874731959196 | -65.14891682860849
item 66 | type 4 | sub 1 | January | 0 | -0.3434131317373652 | 0 | 0 | 935.9874731959196 | -65.14891682860849
 |  |  |  |  |  |  |  | total % | -0.06960447516050422