Spreadsheet: 73177d1273822884-excel-2007-help-me-to-set-up-a-pivottable-properly-with-field-setting-difference-from-testtest
Sheet: Sheet1

id | date | reva | revb | reva % | revb %
12222 | 20070629 | 17.57 | 0.1 |  |  |  |  |  |  | Row Labels | 20040331 | reva % | 20040630 | reva % | 20040930 | reva % | 20041231 | reva % | 20050331 | reva % | 20050630 | reva %
12224 | 20070629 | 17.57 | 1.1 |  |  |  |  |  |  | 2708 | 14.03 |  | 14.12 |  | 14.13 |  | 15.03 |  | 14.75 |  | 15.14
12225 | 20070629 | 17.59 | 20.2 |  |  |  |  |  |  | 2769 | 22.03 | 0.5702066999287243 | 22.43 | 0.5885269121813033 | 21.12 | 0.4946921443736729 | 23.14 | 0.5395874916833001 | 21.88 | 0.4833898305084745 | 22.17 | 0.464332892998679
12227 | 20070629 | 17.83 | 193.4 |  |  |  | Should look like this ->>>> |  |  | 2770 | 22.26 | 0.01044030866999557 | 22.68 | 0.01114578689255463 | 21.37 | 0.0118371212121211 | 23.42 | 0.01210025929127068 | 22.16 | 0.01279707495429627 | 22.46 | 0.01308073973838519
14768 | 20070629 | 19.67 | 0.2 |  |  |  |  |  |  | 2772 | 21.96 | -0.01347708894878707 | 22.35 | -0.01455026455026442 | 21.03 | -0.01591015442208699 | 23.04 | -0.0162254483347567 | 21.78 | -0.01714801444043312 | 22.06 | -0.01780943900267151
14771 | 20070629 | 19.23 | 48.3 |  |  |  |  |  |  | 2773 | 21.82 | -0.006375227686703178 | 22.17 | -0.008053691275167751 | 20.84 | -0.00903471231573949 | 22.82 | -0.00954861111111105 | 21.55 | -0.01056014692378326 | 21.8 | -0.01178603807796907
14773 | 20070629 | 17.61 | 29.6 |  |  |  |  |  |  | 2776 | 12.11 | -0.4450045829514208 | 12.18 | -0.4506089309878214 | 11.77 | -0.4352207293666027 | 9.38 | -0.5889570552147239 | 9.43 | -0.5624129930394433 |  | -1
14774 | 20070629 | 17.66 | 22.1 |  |  |  |  |  |  | 2801 | 10.6 | -0.1246903385631709 | 10.74 | -0.1182266009852216 | 10.83 | -0.07986406117247236 | 11.88 | 0.2665245202558635 | 11.96 | 0.2682926829268295 | 11.93 | #N/A
14775 | 20070629 | 19.18 | 150.9 |  |  |  |  |  |  | 2805 |  | -1 |  | -1 |  | -1 |  | -1 |  | -1 |  | -1
18505 | 20061229 | 23.09 | 142 |  |  |  |  |  |  | 2889 | 11.32 | #N/A | 11.4 | #N/A | 11.01 | #N/A | 10.76 | #N/A | 10.32 | #N/A | 10.37 | #N/A
14284 | 20040331 | 20.09 | 0.3 |  |  |  |  |  |  | 2890 | 11.23 | -0.007950530035335635 | 11.3 | -0.00877192982456132 | 10.91 | -0.009082652134423275 | 10.66 | -0.009293680297397744 | 10.22 | -0.009689922480620172 | 10.27 | -0.009643201542912205
14285 | 20040331 | 20.27 | 11.5 |  |  |  |  |  |  | 2896 | 11.07 | -0.01424755120213717 | 11.14 | -0.01415929203539823 | 10.76 | -0.01374885426214489 | 10.49 | -0.01594746716697937 | 10.06 | -0.01565557729941291 | 10.11 | -0.01557935735150928
14286 | 20040331 | 20.31 | 54.3 |  |  |  |  |  |  | 2897 | 11.17 | 0.009033423667569984 | 11.22 | 0.007181328545780907 | 10.82 | 0.005576208178438735 | 10.56 | 0.006673021925643452 | 10.12 | 0.005964214711729587 | 10.17 | 0.005934718100890191
14284 | 20040630 | 19.87 | 0.3 |  |  |  |  |  |  | 2898 | 11.09 | -0.0071620411817368 | 11.14 | -0.007130124777183555 | 10.74 | -0.007393715341959317 | 10.48 | -0.007575757575757569 | 10.05 | -0.006916996047430679 | 10.1 | -0.0068829891838742
14285 | 20040630 | 20.08 | 13.8 |  |  |  |  |  |  | 2899 | 11.93 | 0.07574391343552755 | 12.36 | 0.1095152603231597 | 12.03 | 0.1201117318435754 | 12.81 | 0.2223282442748091 | 12.72 | 0.2656716417910447 | 12.66 | 0.2534653465346535
14286 | 20040630 | 20.11 | 54.8 |  |  |  |  |  |  | 2907 |  | -1 |  | -1 |  | -1 | 13.54 | 0.0569867291178765 | 13.36 | 0.05031446540880502 | 13.54 | 0.06951026856240117
18505 | 20050930 | 9.31 | 90.1 |  |  |  |  |  |  | 2909 | 12.91 | #N/A | 12.99 | #N/A | 12.25 | #N/A | 13.51 | -0.002215657311669061 | 13.31 | -0.00374251497005984 | 13.47 | -0.005169867060561217
29212 | 20060331 | 47.16 | 145.4 |  |  |  |  |  |  | 2910 | 11.29 | -0.1254841208365609 | 11.28 | -0.1316397228637414 | 10.82 | -0.116734693877551 | 11.7 | -0.1339748334566988 | 11.3 | -0.1510142749812171 | 11.36 | -0.1566443949517446
29212 | 20060630 | 44.6 | 132.3
18505 | 20051230 | 9.73 | 97.6
18505 | 20060331 | 21.87 | 114.1