Spreadsheet: 27629d1221024422-pivot-issue-want-some-row-items-values-on-pivot-but-all-in-total-subtotal-example
Sheet: Sheet1

date | Store | subcategory | Qty | SumIf | Mytotal
2008-01-01 00:00:00 | East | Apples | 5 | 81 | 0.06172839506172839
2008-01-02 00:00:00 | East | Apples | 6 | 81 | 0.07407407407407407 |  |  |  | Data
2008-01-03 00:00:00 | East | Oranges | 7 | 81 | 0.08641975308641975 |  | Store | subcategory | Sum of Qty | % of Store | % of Total
2008-01-04 00:00:00 | East | Oranges | 8 | 81 | 0.09876543209876543 |  | East | Apples | 11 | 0.1358024691358025 | 0.01077375122428991
2008-01-05 00:00:00 | East | Oranges | 9 | 81 | 0.1111111111111111 |  |  | Bananas | 36 | 0.4444444444444444 | 0.03525954946131244
2008-01-06 00:00:00 | East | Oranges | 10 | 81 | 0.1234567901234568 |  |  | Oranges | 34 | 0.4197530864197531 | 0.03330068560235064
2008-01-07 00:00:00 | East | Bananas | 11 | 81 | 0.1358024691358025 |  | East Total |  | 81 | 1 | 0.07933398628795299
2008-01-08 00:00:00 | East | Bananas | 12 | 81 | 0.1481481481481481 |  | North | Apples | 21 | 0.1666666666666667 | 0.02056807051909892
2008-01-09 00:00:00 | East | Bananas | 13 | 81 | 0.1604938271604938 |  |  | Bananas | 51 | 0.4047619047619047 | 0.04995102840352596
2008-01-01 00:00:00 | West | Apples | 20 | 216 | 0.09259259259259259 |  |  | Oranges | 54 | 0.4285714285714286 | 0.05288932419196866
2008-01-02 00:00:00 | West | Apples | 21 | 216 | 0.09722222222222222 |  | North Total |  | 126 | 1 | 0.1234084231145935
2008-01-03 00:00:00 | West | Oranges | 22 | 216 | 0.1018518518518518 |  | South | Apples | 81 | 0.1354515050167224 | 0.07933398628795299
2008-01-04 00:00:00 | West | Oranges | 23 | 216 | 0.1064814814814815 |  |  | Bananas | 153 | 0.2558528428093645 | 0.1498530852105779
2008-01-05 00:00:00 | West | Oranges | 24 | 216 | 0.1111111111111111 |  |  | Oranges | 364 | 0.6086956521739131 | 0.356513222331048
2008-01-06 00:00:00 | West | Oranges | 25 | 216 | 0.1157407407407407 |  | South Total |  | 598 | 1 | 0.5857002938295789
2008-01-07 00:00:00 | West | Bananas | 26 | 216 | 0.1203703703703704 |  | West | Apples | 41 | 0.1898148148148148 | 0.04015670910871694
2008-01-08 00:00:00 | West | Bananas | 27 | 216 | 0.125 |  |  | Bananas | 81 | 0.375 | 0.07933398628795299
2008-01-09 00:00:00 | West | Bananas | 28 | 216 | 0.1296296296296296 |  |  | Oranges | 94 | 0.4351851851851852 | 0.0920666013712047
2008-01-01 00:00:00 | North | Apples | 10 | 126 | 0.07936507936507936 |  | West Total |  | 216 | 1 | 0.2115572967678746
2008-01-02 00:00:00 | North | Apples | 11 | 126 | 0.0873015873015873 |  | Grand Total |  | 1021 | 4 | 1
2008-01-03 00:00:00 | North | Oranges | 12 | 126 | 0.09523809523809523
2008-01-04 00:00:00 | North | Oranges | 13 | 126 | 0.1031746031746032
2008-01-05 00:00:00 | North | Oranges | 14 | 126 | 0.1111111111111111
2008-01-06 00:00:00 | North | Oranges | 15 | 126 | 0.119047619047619
2008-01-07 00:00:00 | North | Bananas | 16 | 126 | 0.126984126984127
2008-01-08 00:00:00 | North | Bananas | 17 | 126 | 0.1349206349206349
2008-01-09 00:00:00 | North | Bananas | 18 | 126 | 0.1428571428571428
2008-01-01 00:00:00 | South | Apples | 40 | 598 | 0.06688963210702341
2008-01-02 00:00:00 | South | Apples | 41 | 598 | 0.06856187290969899
2008-01-03 00:00:00 | South | Oranges | 42 | 598 | 0.07023411371237458
2008-01-04 00:00:00 | South | Oranges | 43 | 598 | 0.07190635451505016
2008-01-05 00:00:00 | South | Oranges | 44 | 598 | 0.07357859531772576
2008-01-06 00:00:00 | South | Oranges | 45 | 598 | 0.07525083612040134
2008-01-03 00:00:00 | South | Oranges | 46 | 598 | 0.07692307692307693
2008-01-04 00:00:00 | South | Oranges | 47 | 598 | 0.07859531772575251
2008-01-05 00:00:00 | South | Oranges | 48 | 598 | 0.0802675585284281
2008-01-06 00:00:00 | South | Oranges | 49 | 598 | 0.08193979933110368
2008-01-07 00:00:00 | South | Bananas | 50 | 598 | 0.08361204013377926
2008-01-08 00:00:00 | South | Bananas | 51 | 598 | 0.08528428093645485
2008-01-09 00:00:00 | South | Bananas | 52 | 598 | 0.08695652173913043