Spreadsheet: 158979d1338470765-extracting-data-related-to-a-single-month-from-a-whole-range-of-data-pivot-table-problem1
Sheet: Monthly

2012-03-01 00:00:00
a | 0 |  |  | 0 |  |  |  |  | x | 0.52763 | 0.0003000012062289664 | 0.00587 | 0.5338000012062291 |  | 0.10241 |  | 0.6362100012062291
 | 50 |  |  | 0.5 |  |  |  |  | x | 0.57351 | 0.0003000012062289664 | 0.00587 | 0.579680001206229 |  | 0.11121 |  | 0.690890001206229
 | 100 |  |  | 1 |  |  |  |  | x | 0.61939 | 0.0003000012062289664 | 0.00587 | 0.625560001206229 |  | 0.12001 |  | 0.745570001206229
 | a |  |  | 0.41 |  |  |  |  | x | 0.56525 | 0.0003000012062289664 | 0.00587 | 0.571420001206229 |  | 0.10963 |  | 0.681050001206229
 |  |  |  |  |  | Total
b | 0 |  |  | 0 |  |  |  |  | x | 0.67125 | 0.0003979918700167666 | 0.00779 | 0.6794379918700167 |  | 0.13035 |  | 0.8097879918700167
 | 50 |  |  | 0.5 |  |  |  |  | x | 0.76714 | 0.0003979918700167666 | 0.00779 | 0.7753279918700168 |  | 0.14875 |  | 0.9240779918700168
 | 100 |  |  | 1 |  |  |  |  | x | 0.86303 | 0.0003979918700167666 | 0.00779 | 0.8712179918700167 |  | 0.16714 |  | 1.038357991870017
 | a |  |  | 0.41 |  |  |  |  | x | 0.74988 | 0.0003979918700167666 | 0.00779 | 0.7580679918700167 |  | 0.14543 |  | 0.9034979918700168
c | 0 |  |  | 0 |  |  |  |  | x | 0.79814 | 0.0005221374377284296 | 0.01022 | 0.8088821374377284 |  | 0.15518 |  | 0.9640621374377284
 | 50 |  |  | 0.5 |  |  |  |  | x | 0.97334 | 0.0005221374377284296 | 0.01022 | 0.9840821374377284 |  | 0.1888 |  | 1.172882137437729
 | 100 |  |  | 1 |  |  |  |  | x | 1.14854 | 0.0005221374377284296 | 0.01022 | 1.159282137437728 |  | 0.22241 |  | 1.381692137437728
 | a |  |  | 0.5298245614035088 |  |  |  |  | x | 0.98379 | 0.0005221374377284296 | 0.01022 | 0.9945321374377285 |  | 0.1908 |  | 1.185332137437729
 |  |  |  |  |  |  |  |  | x | 0.82903 | 0.00044 | 0.00861 | 0.83808 |  | 0.16079 |  | 0.99887
d | 0 |  |  | 0 |  |  |  |  | x | 0.69214 | 0.0009450055727554179 | 0.00880820803824758 | 0.701893213611003 |  | 0.13466 |  | 0.836553213611003
 | 50 |  |  | 0.5 |  |  |  |  | x | 0.86518 | 0.0009450055727554179 | 0.00880820803824758 | 0.874933213611003 |  | 0.16786 |  | 1.042793213611003
 | 100 |  |  | 1 |  |  |  |  | x | 1.03822 | 0.0009450055727554179 | 0.00880820803824758 | 1.047973213611003 |  | 0.20105 |  | 1.249023213611003
 | a |  |  | 0.45 |  |  |  |  | x | 0.84788 | 0.0009450055727554179 | 0.00880820803824758 | 0.857633213611003 |  | 0.16454 |  | 1.022173213611003
e | 0 |  |  | 0 |  |  |  |  | x | 0.69793 | 0.00109421052631579 | 0.01019891758450437 | 0.7092231281108202 |  | 0.13606 |  | 0.8452831281108202
 | 50 |  |  | 0.5 |  |  |  |  | x | 0.93057 | 0.00109421052631579 | 0.01019891758450437 | 0.9418631281108202 |  | 0.1807 |  | 1.12256312811082
 | 100 |  |  | 1 |  |  |  |  | x | 1.16321 | 0.00109421052631579 | 0.01019891758450437 | 1.17450312811082 |  | 0.22533 |  | 1.39983312811082
 | a |  |  | 0.61 |  |  |  |  | x | 0.98175 | 0.00109421052631579 | 0.01019891758450437 | 0.9930431281108202 |  | 0.19051 |  | 1.18355312811082
 |  |  |  | 0.6 |  |  |  |  | x | 0.969 | 0.00108 | 0.01007 | 0.98015 |  | 0.18804 |  | 1.16819
 |  |  |  | 0.58 |  |  |  |  | x | 0.89522 | 0.00077 | 0.0093 | 0.90529 |  | 0.17368 |  | 1.07897
 |  | Total
f |  |  |  | 0.3674999999999999 |  |  |  |  | x | 0.1940698981714309 | 0.0002400876847440356 | 0.0008353472140986256 | 0.1951453330702736 |  | 0.03744
g |  |  |  | 0.3674999999999999 |  |  |  |  | x | 0.2111079385234726 | 0.0002400876847440356 | 0.0008353472140986256 | 0.2121833734223152 |  | 0.04071
h |  |  |  | 0.4125 |  |  |  |  | x | 0.2557534198784565 | 0.0002565065882786675 | 0.001829715385138794 | 0.257839641851874 |  | 0.04947
i |  |  |  | 0.4027542620270901 |  |  |  |  | x | 0.2404517215159322 | 0.0002512661530807651 | 0.001512342062845895 | 0.2422153297318589 |  | 0.04647
j |  |  |  | 0.3674999999999999 |  |  |  |  | x | 0.1570276184137748 | 6.252277467340546e-05 | 0.001068106147173921 | 0.1581582473356221 |  | 0.03034
k |  |  |  | 0.3674999999999999 |  |  |  |  | x | 0.2247994316526789 | 6.252277467340546e-05 | 0.001529091870939101 | 0.2263910462982914 |  | 0.04343
l |  |  |  | 0.4125 |  |  |  |  | x | 0.2691404395961074 | 6.252277467340546e-05 | 0.001830700617442952 | 0.2710336629882237 |  | 0.052
m |  |  |  | 0.4027542620270901 |  |  |  |  | x | 0.2508029201731869 | 6.252277467340546e-05 | 0.001705968309729213 | 0.2525714112575895 |  | 0.04846
n |  |  |  | 0.4027542620270901 |  |  |  |  | x | 0.2633430661818463 | 0.0005164915368882393 | 0.001937688268021303 | 0.2657972459867559 |  | 0.03328 |  | 0.29908
o |  |  |  | 0.4027542620270901 |  |  |  |  | x | 0.2382627741645275 | 0.001256330765403825 | 0.001937688268021303 | 0.2414567931979527 |  | 0.0354 |  | 0.27686
p |  |  |  | 0.4027542620270901 |  |  |  |  | x | 0.250160204791792 | 7.424202347304398e-05 | 0.001693945879164955 | 0.25192839269443 |  | 0.04833 |  | 0.30026
 |  | Total
 |  |  |  | 0 |  |  |  |  | x | 0.52763 | 0.0003000012062289664 | 0.00587 | 0.5338000012062291 |  | 0.10241 |  | 0.6362100012062291
 |  |  |  | 0.5 |  |  |  |  | x | 0.57351 | 0.0003000012062289664 | 0.00587 | 0.579680001206229 |  | 0.11121 |  | 0.690890001206229
 |  |  |  | 1 |  |  |  |  | x | 0.61939 | 0.0003000012062289664 | 0.00587 | 0.625560001206229 |  | 0.12001 |  | 0.745570001206229
 |  |  |  | 0.41 |  |  |  |  | x | 0.56525 | 0.0003000012062289664 | 0.00587 | 0.571420001206229 |  | 0.10963 |  | 0.681050001206229
 |  |  |  |  |  | Total
 |  |  |  | 0 |  |  |  |  | x | 0.67125 | 0.0003979918700167666 | 0.00779 | 0.6794379918700167 |  | 0.13035 |  | 0.8097879918700167
 |  |  |  | 0.5 |  |  |  |  | x | 0.76714 | 0.0003979918700167666 | 0.00779 | 0.7753279918700168 |  | 0.14875 |  | 0.9240779918700168
 |  |  |  | 1 |  |  |  |  | x | 0.86303 | 0.0003979918700167666 | 0.00779 | 0.8712179918700167 |  | 0.16714 |  | 1.038357991870017
 |  |  |  | 0.41 |  |  |  |  | x | 0.74988 | 0.0003979918700167666 | 0.00779 | 0.7580679918700167 |  | 0.14543 |  | 0.9034979918700168
 |  |  |  | 0 |  |  |  |  | x | 0.79814 | 0.0005221374377284296 | 0.01022 | 0.8088821374377284 |  | 0.15518 |  | 0.9640621374377284
 |  |  |  | 0.5 |  |  |  |  | x | 0.97334 | 0.0005221374377284296 | 0.01022 | 0.9840821374377284 |  | 0.1888 |  | 1.172882137437729
 |  |  |  | 1 |  |  |  |  | x | 1.14854 | 0.0005221374377284296 | 0.01022 | 1.159282137437728 |  | 0.22241 |  | 1.381692137437728
 |  |  |  | 0.5298245614035088 |  |  |  |  | x | 0.98379 | 0.0005221374377284296 | 0.01022 | 0.9945321374377285 |  | 0.1908 |  | 1.185332137437729
 |  |  |  |  |  |  |  |  | x | 0.82903 | 0.00044 | 0.00861 | 0.83808 |  | 0.16079 |  | 0.99887
 |  |  |  | 0 |  |  |  |  | x | 0.69214 | 0.0009450055727554179 | 0.00880820803824758 | 0.701893213611003 |  | 0.13466 |  | 0.836553213611003
 |  |  |  | 0.5 |  |  |  |  | x | 0.86518 | 0.0009450055727554179 | 0.00880820803824758 | 0.874933213611003 |  | 0.16786 |  | 1.042793213611003
 |  |  |  | 1 |  |  |  |  | x | 1.03822 | 0.0009450055727554179 | 0.00880820803824758 | 1.047973213611003 |  | 0.20105 |  | 1.249023213611003
 |  |  |  | 0.45 |  |  |  |  | x | 0.84788 | 0.0009450055727554179 | 0.00880820803824758 | 0.857633213611003 |  | 0.16454 |  | 1.022173213611003
 |  |  |  | 0 |  |  |  |  | x | 0.69793 | 0.00109421052631579 | 0.01019891758450437 | 0.7092231281108202 |  | 0.13606 |  | 0.8452831281108202
 |  |  |  | 0.5 |  |  |  |  | x | 0.93057 | 0.00109421052631579 | 0.01019891758450437 | 0.9418631281108202 |  | 0.1807 |  | 1.12256312811082
 |  |  |  | 1 |  |  |  |  | x | 1.16321 | 0.00109421052631579 | 0.01019891758450437 | 1.17450312811082 |  | 0.22533 |  | 1.39983312811082
 |  |  |  | 0.61 |  |  |  |  | x | 0.98175 | 0.00109421052631579 | 0.01019891758450437 | 0.9930431281108202 |  | 0.19051 |  | 1.18355312811082
 |  |  |  | 0.6 |  |  |  |  | x | 0.969 | 0.00108 | 0.01007 | 0.98015 |  | 0.18804 |  | 1.16819
 |  |  |  | 0.58 |  |  |  |  | x | 0.89522 | 0.00077 | 0.0093 | 0.90529 |  | 0.17368 |  | 1.07897
 |  | Total
 |  |  |  |  | 0.17 |  |  |  | x | 0.1940698981714309 | 0.0002400876847440356 | 0.0008353472140986256 | 0.1951453330702736 |  | 0.03744
 |  |  |  |  | 0.26 |  |  |  | x | 0.2111079385234726 | 0.0002400876847440356 | 0.0008353472140986256 | 0.2121833734223152 |  | 0.04071
 |  |  |  |  | 0.52 |  |  |  | x | 0.2557534198784565 | 0.0002565065882786675 | 0.001829715385138794 | 0.257839641851874 |  | 0.04947
 |  |  |  |  | 0.43 |  |  |  | x | 0.2404517215159322 | 0.0002512661530807651 | 0.001512342062845895 | 0.2422153297318589 |  | 0.04647
 |  |  |  |  | 0.17 |  |  |  | x | 0.1570276184137748 | 6.252277467340546e-05 | 0.001068106147173921 | 0.1581582473356221 |  | 0.03034
 |  |  |  |  | 0.26 |  |  |  | x | 0.2247994316526789 | 6.252277467340546e-05 | 0.001529091870939101 | 0.2263910462982914 |  | 0.04343
 |  |  |  |  | 0.52 |  |  |  | x | 0.2691404395961074 | 6.252277467340546e-05 | 0.001830700617442952 | 0.2710336629882237 |  | 0.052
 |  |  |  |  | 0.43 |  |  |  | x | 0.2508029201731869 | 6.252277467340546e-05 | 0.001705968309729213 | 0.2525714112575895 |  | 0.04846
 |  |  |  |  | 0.43 |  |  |  | x | 0.2633430661818463 | 0.0005164915368882393 | 0.001937688268021303 | 0.2657972459867559 |  | 0.03328 |  | 0.29908
 |  |  |  |  | 0.43 |  |  |  | x | 0.2382627741645275 | 0.001256330765403825 | 0.001937688268021303 | 0.2414567931979527 |  | 0.0354 |  | 0.27686
 |  |  |  |  | 0.43 |  |  |  | x | 0.250160204791792 | 7.424202347304398e-05 | 0.001693945879164955 | 0.25192839269443 |  | 0.04833 |  | 0.30026
 |  | Total
 |  |  |  | 0 |  |  |  |  | x | 0.52763 | 0.0003000012062289664 | 0.00587 | 0.5338000012062291 |  | 0.10241 |  | 0.6362100012062291
 |  |  |  | 0.5 |  |  |  |  | x | 0.57351 | 0.0003000012062289664 | 0.00587 | 0.579680001206229 |  | 0.11121 |  | 0.690890001206229
 |  |  |  | 1 |  |  |  |  | x | 0.61939 | 0.0003000012062289664 | 0.00587 | 0.625560001206229 |  | 0.12001 |  | 0.745570001206229
 |  |  |  | 0.41 |  |  |  |  | x | 0.56525 | 0.0003000012062289664 | 0.00587 | 0.571420001206229 |  | 0.10963 |  | 0.681050001206229
 |  |  |  |  |  | Total
 |  |  |  | 0 |  |  |  |  | x | 0.67125 | 0.0003979918700167666 | 0.00779 | 0.6794379918700167 |  | 0.13035 |  | 0.8097879918700167
 |  |  |  | 0.5 |  |  |  |  | x | 0.76714 | 0.0003979918700167666 | 0.00779 | 0.7753279918700168 |  | 0.14875 |  | 0.9240779918700168
 |  |  |  | 1 |  |  |  |  | x | 0.86303 | 0.0003979918700167666 | 0.00779 | 0.8712179918700167 |  | 0.16714 |  | 1.038357991870017
 |  |  |  | 0.41 |  |  |  |  | x | 0.74988 | 0.0003979918700167666 | 0.00779 | 0.7580679918700167 |  | 0.14543 |  | 0.9034979918700168
 |  |  |  | 0 |  |  |  |  | x | 0.79814 | 0.0005221374377284296 | 0.01022 | 0.8088821374377284 |  | 0.15518 |  | 0.9640621374377284
 |  |  |  | 0.5 |  |  |  |  | x | 0.97334 | 0.0005221374377284296 | 0.01022 | 0.9840821374377284 |  | 0.1888 |  | 1.172882137437729
 |  |  |  | 1 |  |  |  |  | x | 1.14854 | 0.0005221374377284296 | 0.01022 | 1.159282137437728 |  | 0.22241 |  | 1.381692137437728
 |  |  |  | 0.5298245614035088 |  |  |  |  | x | 0.98379 | 0.0005221374377284296 | 0.01022 | 0.9945321374377285 |  | 0.1908 |  | 1.185332137437729
 |  |  |  |  |  |  |  |  | x | 0.82903 | 0.00044 | 0.00861 | 0.83808 |  | 0.16079 |  | 0.99887
 |  |  |  | 0 |  |  |  |  | x | 0.69214 | 0.0009450055727554179 | 0.00880820803824758 | 0.701893213611003 |  | 0.13466 |  | 0.836553213611003
 |  |  |  | 0.5 |  |  |  |  | x | 0.86518 | 0.0009450055727554179 | 0.00880820803824758 | 0.874933213611003 |  | 0.16786 |  | 1.042793213611003
 |  |  |  | 1 |  |  |  |  | x | 1.03822 | 0.0009450055727554179 | 0.00880820803824758 | 1.047973213611003 |  | 0.20105 |  | 1.249023213611003
 |  |  |  | 0.45 |  |  |  |  | x | 0.84788 | 0.0009450055727554179 | 0.00880820803824758 | 0.857633213611003 |  | 0.16454 |  | 1.022173213611003
 |  |  |  | 0 |  |  |  |  | x | 0.69793 | 0.00109421052631579 | 0.01019891758450437 | 0.7092231281108202 |  | 0.13606 |  | 0.8452831281108202
 |  |  |  | 0.5 |  |  |  |  | x | 0.93057 | 0.00109421052631579 | 0.01019891758450437 | 0.9418631281108202 |  | 0.1807 |  | 1.12256312811082
 |  |  |  | 1 |  |  |  |  | x | 1.16321 | 0.00109421052631579 | 0.01019891758450437 | 1.17450312811082 |  | 0.22533 |  | 1.39983312811082
 |  |  |  | 0.61 |  |  |  |  | x | 0.98175 | 0.00109421052631579 | 0.01019891758450437 | 0.9930431281108202 |  | 0.19051 |  | 1.18355312811082
 |  |  |  | 0.6 |  |  |  |  | x | 0.969 | 0.00108 | 0.01007 | 0.98015 |  | 0.18804 |  | 1.16819
 |  |  |  | 0.58 |  |  |  |  | x | 0.89522 | 0.00077 | 0.0093 | 0.90529 |  | 0.17368 |  | 1.07897
 |  | Total
 |  |  |  |  |  |  |  |  | x | 0.1940698981714309 | 0.0002400876847440356 | 0.0008353472140986256 | 0.1951453330702736 |  | 0.03744
 |  |  |  |  |  |  |  |  | x | 0.2111079385234726 | 0.0002400876847440356 | 0.0008353472140986256 | 0.2121833734223152 |  | 0.04071
 |  |  |  |  |  |  |  |  | x | 0.2557534198784565 | 0.0002565065882786675 | 0.001829715385138794 | 0.257839641851874 |  | 0.04947
 |  |  |  |  |  |  |  |  | x | 0.2404517215159322 | 0.0002512661530807651 | 0.001512342062845895 | 0.2422153297318589 |  | 0.04647
 |  |  |  |  |  |  |  |  | x | 0.1570276184137748 | 6.252277467340546e-05 | 0.001068106147173921 | 0.1581582473356221 |  | 0.03034
 |  |  |  |  |  |  |  |  | x | 0.2247994316526789 | 6.252277467340546e-05 | 0.001529091870939101 | 0.2263910462982914 |  | 0.04343
 |  |  |  |  |  |  |  |  | x | 0.2691404395961074 | 6.252277467340546e-05 | 0.001830700617442952 | 0.2710336629882237 |  | 0.052
 |  |  |  |  |  |  |  |  | x | 0.2508029201731869 | 6.252277467340546e-05 | 0.001705968309729213 | 0.2525714112575895 |  | 0.04846
 |  |  |  |  |  |  |  |  | x | 0.2633430661818463 | 0.0005164915368882393 | 0.001937688268021303 | 0.2657972459867559 |  | 0.03328 |  | 0.29908
 |  |  |  |  |  |  |  |  | x | 0.2382627741645275 | 0.001256330765403825 | 0.001937688268021303 | 0.2414567931979527 |  | 0.0354 |  | 0.27686
 |  |  |  |  |  |  |  |  | x | 0.250160204791792 | 7.424202347304398e-05 | 0.001693945879164955 | 0.25192839269443 |  | 0.04833 |  | 0.30026