Spreadsheet: 593641d1539259582-pivot-and-problem-with-dates-pivot-and-date-new-version
Sheet: Pivot-1

 | Duedate | (All)
 | Row Labels | Sum of Amount |  |  | .
 | 00/SRI17107 | 90625.38
 | 00/SRI17170 | 298511.12
 | 00/SRI17182 | 49245.72
 | 00/SRI17192 | 699624.92
 | 00/SRI17205 | 45866.42
 | [PHONE] | 6717
 | 000368 | 468750
 | [PHONE] | -100000
 | 04668159 | 412.5
 | 09-18 | 26425
 | 10001987 | 7637.28
 | 100086 | 3576.42
 | 1001041 | 7470
 | 1001463 | 3125
 | 1001464 | 15837.5
 | 10015020 | 12375
 | 10021 | 9084.33
 | 100216 | 2850
 | 100285 | 122000
 | 10029 | 5000
 | 1003 | 85531.25
 | 10061 | 26500
 | 10081 | 149771.25
 | 10083 | 6581.25
 | 10091 | 5062.5
 | 100961728 | 241.34
 | 100964778 | 397.02
 | 100964779 | 1379.55
 | 100967818 | 1364.52
 | 10120 | 2025
 | 10141 | 1500
 | 10157 | 7133
 | 1016769 | 170
 | [PHONE] | 6244
 | 10211 | 6105
 | 102199 | 31050
 | 1025 | 114984.38
 | 1025497 | 1999.99
 | [PHONE] | 6470
 | 1026083 | 108
 | 10630 | 15468
 | [PHONE] | 2023
 | [PHONE] | 2023
 | 10724 | 1625
 | 10725 | 93625
 | 10726 | 44062.5
 | 107529420 | 2052
 | 10765 | 66000
 | 10766 | 117187.5
 | 107861393 | -2052
 | 10944 | 24466.69
 | [PHONE] | 3979.43
 | [PHONE] | 3737.5
 | [PHONE] | 1737.5
 | [PHONE] | 1092.5
 | 112 | 9075
 | 1125430 | 39635.25
 | 120953 | 53617.5
 | 123009 | 11900
 | 124215 | 5158.75
 | 124323 | 8524.81
 | 12749 | 2362.5
 | 12750 | 7481.25
 | 12754 | 393.75
 | 12755 | 3937.5
 | 129289 | 6208.75
 | 129493 | 6396.25
 | 129942 | -4231.25
 | 129947 | -6392.5
 | 129948 | -6208.75
 | 129950 | -6396.25
 | 130989 | 5958.75
 | 131049 | 6333.75
 | 131050 | 6333.75
 | 131246 | 3271.25
 | 1338565 | 312.8
 | 14163 | 6741.46
 | 14429 | 24946.61
 | 14432 | 6760.03
 | 14511 | 7012.3
 | 14512 | 25069.06
 | 14515 | 6793.21
 | 14597 | 7341.43
 | 14598 | 26245.69
 | 14601 | 7112.05
 | 1469013 | 12.18
 | 14695 | 7113.6
 | 14696 | 25431.22
 | 14697 | 23341.55
 | 14698 | 7335.95
 | 14699 | 6891.35
 | 14718 | 12448.81
 | [PHONE] | 468.75
 | [PHONE] | 263.92
 | 15900 | 2329
 | 1619344 | 18032
 | 1619438 | 25875
 | 1619502 | 743
 | 1619667 | 4900
 | 1619711 | 6806.25
 | 18000811 | 65625
 | 18017 | 2500
 | 18213307 | 50314
 | 19236 | 5363
 | [PHONE] | 7452.5
 | [PHONE] | 7452.5
 | 20004 | -2656.25
 | 2009 | 728.07
 | 2022210 | 90447.84
 | 2022520 | 87536.16
 | 202340 | 164015
 | 2023873 | 37487.04
 | 212102182000893 | 20465
 | 215433 | 31125
 | 215504 | 40500
 | 2156667 | 8750
 | 2158064 | 2424
 | 2158066 | 1350
 | 2158073 | 1000
 | 2169084 | 135.35
 | 2193878 | 156250
 | 2193879 | 156250
 | 22180032 | 4950
 | 22180068 | -2842.68
 | 22180095 | 2163.15
 | 22180101 | 25000
 | 22180112 | 4775
 | 22180186 | 3078.2
 | 22205864 | 319
 | [PHONE] | 3302.93
 | [PHONE] | 1407.43
 | [PHONE] | 730.6
 | [PHONE] | 7352.13
 | 2266027-test2 | 1663
 | 2282517 | -431
 | 2325023 | -20669
 | 2336217 | 2140
 | 2369274 | 2079.2
 | 2369303 | 9960.6
 | 2389877 | 3790.2
 | 2389930 | 1777.2
 | 2389951 | 1752.6
 | 2389954 | 1958.2
 | 2411948 | 3260.13
 | 2411964 | 6618
 | 2412005 | 2892.7
 | 2427112 | 3800
 | 2427115 | 4120
 | 2427119 | -6519.5
 | 2427121 | 9412.51
 | 2427128 | 5867.5
 | 2427134 | -2078.72
 | 2427135 | 45574
 | 2427138 | 1693.04
 | 2427153 | 21041
 | 2427155 | 2864
 | 2427167 | 631.28
 | 2427172 | 2565
 | 2427176 | 3435.88
 | 2446530 | 3051.88
 | 2446531 | -30.9
 | 2446535 | 2194.2
 | 2446551 | 3873.2
 | 2446554 | 2240
 | 2446555 | 8305
 | 2446557 | 2240
 | 2446558 | 1998.2
 | 2446563 | 7503
 | 2446564 | 1876.2
 | 2446589 | 1285
 | 2446590 | 1807.2
 | 2446596 | 16531
 | 2446620 | 1442
 | 2446621 | 2125.88
 | 2446639 | 3252.88
 | 2446649 | 2591.76
 | 2446665 | 1117
 | 2446702 | 7844
 | 2446704 | 862.88
 | 2446705 | 862.88
 | 2446714 | 2364.76
 | 2446732 | 7260
 | 2446735 | 1549.5
 | 2446738 | 1539.91
 | 2446748 | 800
 | 2446749 | 123.2
 | 2446785 | -3193.5
 | 2446836 | 1324
 | 2446856 | 2236.6
 | 2446858 | 2350.2
 | 2446859 | -30.5
 | 2465 | 8075
 | 2469745 | 424.5
 | 2469746 | 1850.24
 | 2469747 | 1106
 | 2469748 | 235.2
 | 2469749 | 2659.88
 | 2469750 | 942
 | 2469751 | 1757
 | 2469752 | 2069.5
 | 2469754 | 4729
 | 2469755 | -249.5
 | 2469756 | 9626
 | 2469759 | 3497.88
 | 2469763 | 2663.2
 | 2469765 | 4972
 | 2469766 | 4219
 | 2469767 | 3666.2
 | 2469775 | 7994
 | 2469776 | 2654.88
 | 2469783 | 11763
 | 2469785 | 2550
 | 2469790 | 156.8
 | 2469791 | -240
 | 2469792 | 1668
 | 2469794 | 2686.2
 | 2469795 | 78.4
 | 2469807 | 2834
 | 2469812 | 3139
 | 2469813 | 3574.76
 | 2469814 | 1084
 | 2469816 | 2090.65
 | 2469817 | 5204.2
 | 2469821 | 2389.88
 | 2469822 | 2389.88
 | 2469826 | 1417.2
 | 2469827 | 13382
 | 2469828 | 1921.2
 | 2469831 | 6498.2
 | 2469832 | 4028.8
 | 2469833 | 1884
 | 2469834 | 1884
 | 2469835 | 20309
 | 2469841 | 2286.2
 | 2469845 | 6277.2
 | 2469846 | 320
 | 2469847 | 320
 | 2469849 | 2880.2
 | 2469860 | 2727
 | 2469862 | 2073.88
 | 2469866 | 1885
 | 2469868 | 4793
 | 2469871 | 4232.2
 | 2469872 | -620.5
 | 2469873 | 1527
 | 2469874 | 5992.2
 | 2469878 | 3609.28
 | 2469883 | 6590
 | 2469890 | 2654.6
 | 2469891 | 4802
 | 2469898 | 5203
 | 2469901 | 3005
 | 2469903 | 2291.2
 | 2469904 | 1322
 | 2469905 | 2832.3
 | 2469906 | 8713
 | 2469911 | 4203
 | 2469912 | 1982
 | 2469914 | -6880.83
 | 2469916 | 4543.2
 | 2469917 | 1849.28
 | 2469923 | 70
 | 2469931 | 2936.62
 | 2469932 | 3091.2
 | 2469936 | 1071.88
 | 2469939 | 5365
 | 2469940 | 912.88
 | 2469941 | 1243.4
 | 2469942 | 1243.4
 | 2469946 | 7682
 | 2469947 | 536.5
 | 2469948 | 411
 | 2469949 | 6405
 | 2469950 | 10441.4
 | 2469951 | -4225.5
 | 2469952 | 3272.2
 | 2469953 | 100
 | 2469956 | 78.4
 | 2469957 | 1126.75
 | 2469958 | 78.4
 | 2469961 | 400
 | 2469962 | 10250
 | 2469963 | 1719.76
 | 2469967 | 6727
 | 2469974 | 187.5
 | 2469975 | -1892.5
 | 2469976 | -285.5
 | 2469979 | 3020.2
 | 2469982 | 11304
 | 2469984 | 1873
 | 2469988 | 7550
 | 2469989 | 3066
 | 2469993 | 4308.2
 | 2469994 | 133.28
 | 2469995 | -429.5
 | 2469997 | 5581.58
 | 2470004 | 4684
 | 2470005 | 1018.6
 | 2470006 | 2476.6
 | 2470008 | 1602.4
 | 2470011 | 4104
 | 2470014 | 4122
 | 2470015 | 422.7
 | 2470016 | 1770.88
 | 2470017 | 15407
 | 2470022 | 512.5
 | 2470023 | 3283
 | 2470024 | 5086.6
 | 2470025 | 2141.4
 | 2470026 | 2096.2
 | 2470028 | 0
 | 2470030 | -621.4
 | 2470031 | 1104
 | 2470032 | 70
 | 2470033 | 156.8
 | 2470039 | 2075
 | 2470040 | 1299.6
 | 2470044 | 2034
 | 2470046 | 1242.4
 | 2470048 | 3511
 | 2470049 | 156.8
 | 2470050 | -5234.52
 | 2470052 | 2140.2
 | 2470053 | 2400.2
 | 2470055 | 5086
 | 2470057 | 2140.2
 | 2470058 | 2105.2
 | 2470059 | 1120.2
 | 2470060 | 1839.2
 | 2470061 | 8362
 | 2470062 | 2105.2
 | 2470063 | 3175.4
 | 2470064 | 2131
 | 2470066 | 1809.4
 | 2470067 | 1455
 | 2470068 | 960.15
 | 2470069 | 347.2
 | 2470071 | 2278
 | 2470074 | 2776.2
 | 2470075 | 2776.2
 | 2470078 | 1609.76
 | 2470080 | 3193.2
 | 2470081 | 3478
 | 2470082 | 3035
 | 2470083 | 1135
 | 2470084 | 7568
 | 2470086 | 1451.4
 | 2470087 | 2518.88
 | 2470090 | 4834
 | 2470091 | 2684.64
 | 2470092 | 8706
 | 2470093 | 70
 | 2470094 | 8842
 | 2470098 | 909
 | 2470100 | 1456
 | 2470106 | 17911
 | 2470107 | 7776
 | 2470108 | 4150.6
 | 2470110 | 712
 | 2470111 | 962.88
 | 2470112 | 1119.88
 | 2470114 | 10159
 | 2470117 | 711
 | 2470118 | 1047.2
 | 2470119 | 1899.2
 | 2470120 | 1899.2
 | 2470126 | 1287.75
 | 2470131 | 1724.65
 | 2470132 | 6579
 | 2470135 | 3271.8
 | 2470140 | 1260.05
 | 2470144 | 2299
 | 2470147 | 5869
 | 248806 | 11288
 | 252916 | 562864
 | 253536 | 2625
 | 253991 | 313
 | 2598 | 1620
 | 2617825 | 297.98
 | 2617826 | 82.36
 | 27050 | 3610
 | 27051 | 2355
 | 27827059 | 10328.41
 | 28.09.2018 | 2885.51
 | [PHONE] | 325
 | [PHONE] | 476
 | 28204090 | 3051
 | 28211439 | 47172
 | 2965 | 18125
 | 29788 | 2125
 | 30005879 | 9500
 | 30005880 | 9500
 | 30005881 | 9500
 | 30006786 | 38000
 | 300333611 | 1310
 | 306 | 7750
 | 308396 | 63297.5
 | 31194 | 2590
 | 33592950 | 1066.76
 | 34099 | 42005
 | 3513 | 16848
 | 36147 | 1740
 | 364 | 6000
 | 36918 | 31250
 | 38004249 | 19425
 | 38004249-1 | -19425
 | 38004249-2 | -19425
 | 38033289 | 274604
 | 38036234 | 11156
 | 38037993 | 165600
 | [PHONE] | 2437.5
 | [PHONE] | 2437.5
 | [PHONE] | 3500
 | [PHONE] | 3500
 | [PHONE] | 3500
 | [PHONE] | 3500
 | [PHONE] | 3500
 | [PHONE] | 2437.5
 | [PHONE] | 3500
 | 38272 | 346.95
 | 38369 | 343.46
 | 38542 | 2590
 | 38627 | 2215
 | 390 | -7750
 | [PHONE] | 2377.5
 | 391 | -6000
 | 412 | 15540
 | 416734 | -2950
 | 41807055 | 4000
 | 429089 | 28375
 | 433550808 | 700.5
 | 44264 | 3647
 | 45080878 | 24250
 | 4615924 | 1475
 | 47011638 | 861
 | 47910 | 3908
 | 4802349 | 6914
 | 4911852 | 3351
 | 505825339 | 294285.42
 | 521034 | 186695.09
 | [PHONE] | -274.96
 | 606429 | 93718.31
 | 63 | 4530
 | 639 | 2656.25
 | [PHONE] | 416.7
 | 6755684 | 175
 | 6757450 | 175
 | 700025 | 16646
 | 707706 | 567
 | 708949037 | 33606.72
 | 709440 | 51876
 | 73989785 | 19899.43
 | 75031141 | 9116
 | 751 | 11875
 | 7812 | 4742607
 | 8 | 12750
 | 81226517 | 1089.52
 | 814068602 | 1224.53
 | 814153361 | 2391.07
 | 814238255 | 3053.16
 | 82380 | 2884.15
 | 8459 | 5250
 | 89498 | 25000
 | 900203732 | 95.89
 | 90472994 | 24219
 | 90473891 | 6379
 | 90474611 | 49468
 | 90476032 | -50000
 | 90476656 | 11741
 | 91184098 | 560.05
 | 9161036 | 995
 | 917241 | 7553
 | 919560767 | 6107.94
 | 919612663 | 20099.25
 | 919631617 | 9092.09
 | 919632501 | 4471.8
 | 919650836 | 2358.75
 | 919652473 | 2755.7
 | [PHONE] | 3337.5
 | 9292761 | 687
 | [PHONE] | 386
 | 982028481 | -993.75
 | 982034014 | -1199
 | 994299 | 3125
 | INV0138460349 | 5485.530000000002
 | INV0138493976 | 396.55
 | INV0139631611 | 5367.25
 | INV0139653172 | 1035.32
 | INV0139665326 | 380.42
 | INV0139695087 | 4674.280000000001
 | MN11015478 | 76531.25
 | MN11019415 | 31448.25
 | N554101001114 | 240
 | RN10000965 | 10000
 | RN10000977 | 10000
 | RN10000978 | 10000
 | RN10000979 | 30000
 | Saksnr:159711418 | 2245.51
 | Grand Total | 12023319.87000001