Spreadsheet: 184613d1349324954-of-accumulated-sub-total-in-pivot-table-pivot-sample
Sheet: Pivot

 |  |  |  |  |  |  |  |  |  | This is the Ideal Pivot Table I want
 |  |  | Month |  |  |  |  |  |  | This is the Ideal Pivot Table I want |  |  | Month
Branch | Item | [NAME] | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 |  | Branch | Item | [NAME] | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00
Hong Kong | Apple | Sold out (Accumulated) | 476 | 718 | 733 | 1038 | 1415 | 1704 |  | Hong Kong | Apple | Sold out (Accumulated) | 476 | 718 | 733 | 1038 | 1415 | 1704
 |  | % / Sold out | 0.2311801845556095 | 0.1300376141859216 | 0.006162695152013147 | 0.1407475772958006 | 0.165061295971979 | 0.1415972562469378 |  |  |  | % / Sold out | 0.6134020618556701 | 0.458492975734355 | 0.3480531813865147 | 0.3417846559104379 | 0.3410460351892022 | 0.3620909477263068
 | Lemon | Sold out (Accumulated) | 228 | 535 | 874 | 1271 | 1634 | 1680 |  |  | Lemon | Sold out (Accumulated) | 228 | 535 | 874 | 1271 | 1634 | 1680
 |  | % / Sold out | 0.1107333657115104 | 0.1649650725416443 | 0.1392769104354971 | 0.1832025842178126 | 0.1589316987740806 | 0.02253797158255757 |  |  |  | % / Sold out | 0.2938144329896907 | 0.3416347381864623 | 0.4150047483380817 | 0.4185051037207771 | 0.3938298385153049 | 0.3569910752231194
 | Orange | Sold out (Accumulated) | 72 | 313 | 499 | 728 | 1100 | 1322 |  |  | Orange | Sold out (Accumulated) | 72 | 313 | 499 | 728 | 1100 | 1322
 |  | % / Sold out | 0.03496843127731909 | 0.1295002686727566 | 0.07641741988496302 | 0.1056760498384864 | 0.1628721541155867 | 0.1087702106810387 |  |  |  | % / Sold out | 0.09278350515463918 | 0.1998722860791826 | 0.2369420702754036 | 0.239710240368785 | 0.2651241262954929 | 0.2809179770505738
Hong Kong Sold out (Accumulated) |  |  | 776 | 1566 | 2106 | 3037 | 4149 | 4706 |  | Hong Kong Sold out (Accumulated) |  |  | 776 | 1566 | 2106 | 3037 | 4149 | 4706
Hong Kong % / Sold out |  |  | 0.376881981544439 | 0.4245029554003224 | 0.2218570254724733 | 0.4296262113520997 | 0.4868651488616462 | 0.2729054385105341 |  | Hong Kong % / Sold out |  |  | 1 | 1 | 0.9999999999999999 | 1 | 1 | 1
Singapore | Apple | Sold out (Accumulated) | 85 | 259 | 602 | 942 | 1301 | 1686 |  | Singapore | Apple | Sold out (Accumulated) | 85 | 259 | 602 | 942 | 1301 | 1686
 |  | % / Sold out | 0.0412821758135017 | 0.09349811929070392 | 0.1409202958093673 | 0.156898938624827 | 0.1571803852889667 | 0.1886330230279275 |  |  |  | % / Sold out | 0.1266766020864382 | 0.2090395480225989 | 0.3104693140794224 | 0.3244919049259387 | 0.3610879822370247 | 0.3767597765363129
 | Lemon | Sold out (Accumulated) | 362 | 700 | 817 | 992 | 1145 | 1387 |  |  | Lemon | Sold out (Accumulated) | 362 | 700 | 817 | 992 | 1145 | 1387
 |  | % / Sold out | 0.1758135016998543 | 0.1816227834497582 | 0.04806902218570255 | 0.08075680664513152 | 0.0669877408056042 | 0.1185693287604116 |  |  |  | % / Sold out | 0.5394932935916542 | 0.5649717514124294 | 0.4213512119649304 | 0.3417154667585257 | 0.3177907299472661 | 0.3099441340782123
 | Orange | Sold out (Accumulated) | 224 | 280 | 520 | 969 | 1157 | 1402 |  |  | Orange | Sold out (Accumulated) | 224 | 280 | 520 | 969 | 1157 | 1402
 |  | % / Sold out | 0.1087906750849927 | 0.03009134873723805 | 0.09860312243221035 | 0.2071988924780803 | 0.08231173380035026 | 0.1200391964723175 |  |  |  | % / Sold out | 0.3338301043219076 | 0.2259887005649718 | 0.2681794739556472 | 0.3337926283155356 | 0.3211212878157091 | 0.3132960893854749
[NAME] out (Accumulated) |  |  | 671 | 1239 | 1939 | 2903 | 3603 | 4475 |  | [NAME] out (Accumulated) |  |  | 671 | 1239 | 1939 | 2903 | 3603 | 4475
Singapore % / Sold out |  |  | 0.3258863525983487 | 0.3052122514777001 | 0.2875924404272802 | 0.4448546377480387 | 0.3064798598949212 | 0.4272415482606565 |  | Singapore % / Sold out |  |  | 1 | 1 | 1 | 1 | 1 | 1
Taiwan | Apple | Sold out (Accumulated) | 67 | 382 | 831 | 949 | 1006 | 1009 |  | Taiwan | Apple | Sold out (Accumulated) | 67 | 382 | 831 | 949 | 1006 | 1009
 |  | % / Sold out | 0.03254006799417193 | 0.169263836646964 | 0.1844700082169269 | 0.05445316105214582 | 0.02495621716287215 | 0.001469867711905928 |  |  |  | % / Sold out | 0.1094771241830065 | 0.3426008968609865 | 0.3598960588999567 | 0.3676869430453313 | 0.3295119554536521 | 0.2753069577080491
 | Lemon | Sold out (Accumulated) | 397 | 524 | 1001 | 1018 | 1340 | 1784 |  |  | Lemon | Sold out (Accumulated) | 397 | 524 | 1001 | 1018 | 1340 | 1784
 |  | % / Sold out | 0.1928120446818844 | 0.06824288017195057 | 0.1959737058340181 | 0.007844946931241348 | 0.1409807355516637 | 0.2175404213620774 |  |  |  | % / Sold out | 0.6486928104575164 | 0.4699551569506726 | 0.4335210047639671 | 0.3944207671445176 | 0.4389125450376679 | 0.4867667121418827
 | Orange | Sold out (Accumulated) | 148 | 209 | 477 | 614 | 707 | 872 |  |  | Orange | Sold out (Accumulated) | 148 | 209 | 477 | 614 | 707 | 872
 |  | % / Sold out | 0.0718795531811559 | 0.03277807630306287 | 0.1101068200493016 | 0.06322104291647439 | 0.04071803852889667 | 0.08084272415482606 |  |  |  | % / Sold out | 0.2418300653594771 | 0.1874439461883408 | 0.2065829363360762 | 0.2378922898101511 | 0.23157549950868 | 0.2379263301500682
[NAME] out (Accumulated) |  |  | 612 | 1115 | 2309 | 2581 | 3053 | 3665 |  | [NAME] out (Accumulated) |  |  | 612 | 1115 | 2309 | 2581 | 3053 | 3665
Taiwan % / Sold out |  |  | 0.2972316658572122 | 0.2702847931219775 | 0.4905505341002465 | 0.1255191508998616 | 0.2066549912434326 | 0.2998530132288094 |  | Taiwan % / Sold out |  |  | 1 | 1 | 1 | 1 | 0.9999999999999999 | 1
全体の [NAME] out (Accumulated) |  |  | 2059 | 3920 | 6354 | 8521 | 10805 | 12846 |  | 全体の [NAME] out (Accumulated) |  |  | 2059 | 3920 | 6354 | 8521 | 10805 | 12846
全体の % / Sold out |  |  | 1 | 1 | 1 | 1 | 1 | 1 |  | 全体の % / Sold out |  |  | 1 | 1 | 1 | 1 | 1 | 1