Spreadsheet: 542148d1507730498-return-total-amount-values-based-on-multiple-criteria-542074d1507706459-return-total-amount-values-based-on-multiple-criteria-reporting
Sheet: Pivot

For printing purposes, I prefer Verticle (Dates going down) pivot table vs Horizontal (dates going across)
Sum of Amt | Column Labels
Row Labels | CashOutFlow | Forecast PreConstr | ForecastConstr | Grand Total
2017-01-02 00:00:00 | 0 | 0 | 0 | 0
2017-01-09 00:00:00 | 0 | 0 | 0 | 0
2017-01-16 00:00:00 | 0 | 0 | 0 | 0
2017-01-23 00:00:00 | 0 | 0 | 0 | 0
2017-01-30 00:00:00 | 0 | 0 | 0 | 0
2017-02-06 00:00:00 | 0 | 0 | 0 | 0
2017-02-13 00:00:00 | 0 | 0 | 104437.8 | 104437.8
2017-02-20 00:00:00 | 0 | 0 | 0 | 0
2017-02-27 00:00:00 | 0 | 0 | 0 | 0
2017-03-06 00:00:00 | 461882.5200000001 | 0 | 96840.15 | 558722.6700000002
2017-03-13 00:00:00 | 429290.26 | 0 | 243910.35 | 673200.61
2017-03-20 00:00:00 | 755342.2899999999 | 0 | 0 | 755342.2899999999
2017-03-27 00:00:00 | 651602.6900000001 | 0 | 0 | 651602.6900000001
2017-04-03 00:00:00 | 1150756.88 | 0 | 178298.5 | 1329055.38
2017-04-10 00:00:00 | 516454.6800000001 | 0 | 236602.95 | 753057.63
2017-04-17 00:00:00 | 196858.97 | 0 | 0 | 196858.97
2017-04-24 00:00:00 | 1011101.94 | 0 | 411541.75 | 1422643.69
2017-05-01 00:00:00 | 1247516.27 | 0 | 158794.65 | 1406310.92
2017-05-08 00:00:00 | 399943.4599999999 | 0 | 266295.35 | 666238.8099999998
2017-05-15 00:00:00 | 415782.7500000002 | 0 | 399854.5 | 815637.2500000002
2017-05-22 00:00:00 | 394886.51 | 0 | 84097.65 | 478984.1599999999
2017-05-29 00:00:00 | 427784.15 | 0 | 0 | 427784.15
2017-06-05 00:00:00 | 1204404.47 | 0 | 775456.6 | 1979861.07
2017-06-12 00:00:00 | 560550.2699999999 | 0 | 447019.7999999999 | 1007570.07
2017-06-19 00:00:00 | 552288.54 | 0 | 0 | 552288.54
2017-06-26 00:00:00 | 452232.53 | 0 | 674360.25 | 1126592.78
2017-07-03 00:00:00 | 1328004.67 | 0 | 853909.35 | 2181914.02
2017-07-10 00:00:00 | 862840.1200000001 | 0 | 207633.15 | 1070473.27
2017-07-17 00:00:00 | 802481.13 | 0 | 1048483.1 | 1850964.23
2017-07-24 00:00:00 | 960786.08 | 0 | 616839.6 | 1577625.68
2017-07-31 00:00:00 | 1403652.34 | 0 | 516251.227 | 1919903.567
2017-08-07 00:00:00 | 732303.6100000002 | 0 | 441445.55 | 1173749.16
2017-08-14 00:00:00 | 705585.8200000001 | 0 | 488387.55 | 1193973.37
2017-08-21 00:00:00 | 476549.57 | 0 | 442121.595 | 918671.165
2017-08-28 00:00:00 | 498852.58 | 0 | 1237803.65 | 1736656.23
2017-09-04 00:00:00 | 1542325.18 | 0 | 200733.6 | 1743058.78
2017-09-11 00:00:00 | 550149.03 | 0 | 1118362.5 | 1668511.53
2017-09-18 00:00:00 | 399474.27 | 0 | 518301.4 | 917775.6699999999
2017-09-25 00:00:00 | 20761.35 | 34492.25 | 886660.2 | 941913.7999999999
2017-10-02 00:00:00 | 1409665.62 | 46828.85000000001 | 655114 | 2111608.47
2017-10-09 00:00:00 | 62266.94 | 0 | 1251848 | 1314114.94
2017-10-16 00:00:00 | 0 | 0 | 1358029.85 | 1358029.85
2017-10-23 00:00:00 | 0 | 103476.75 | 935394.05 | 1038870.8
2017-10-30 00:00:00 | 0 | 140486.55 | 1161682.65 | 1302169.2
2017-11-06 00:00:00 | 0 | 45826.60000000001 | 452030.8 | 497857.4
2017-11-13 00:00:00 | 0 | 172461.25 | 480567.054 | 653028.304
2017-11-20 00:00:00 | 0 | 234144.25 | 263395.4 | 497539.65
2017-11-27 00:00:00 | 0 | 0 | 774504.1000000001 | 774504.1000000001
2017-12-04 00:00:00 | 0 | 137479.8 | 1040318.15 | 1177797.95
2017-12-11 00:00:00 | 0 | 0 | 332563.6 | 332563.6
2017-12-18 00:00:00 | 0 | 0 | 683910.4 | 683910.4
2017-12-25 00:00:00 |  | 252963.6 | 510830.777 | 763794.377
2018-01-01 00:00:00 |  | 206953.5 | 271931.85 | 478885.35
2018-01-08 00:00:00 |  | 280973.1 | 82601.7 | 363574.8
2018-01-15 00:00:00 |  | 24650.7 | 453129.3 | 477780.0000000001
2018-01-22 00:00:00 |  | 108434.2 | 0 | 108434.2
2018-01-29 00:00:00 |  | 164027.05 | 245932.55 | 409959.6000000001
2018-02-05 00:00:00 |  | 140486.55 | 0 | 140486.55
2018-02-12 00:00:00 |  | 468064.7 | 88975.8 | 557040.5
2018-02-19 00:00:00 |  | 110827.2 | 225946.1 | 336773.3
2018-02-26 00:00:00 |  | 181650.9 | 181287.9 | 362938.8
2018-03-05 00:00:00 |  | 123253.5 | 55067.8 | 178321.3
2018-03-12 00:00:00 |  | 322191.8 | 183451.8 | 505643.6
2018-03-19 00:00:00 |  | 302751.5 | 107158.418 | 409909.918
2018-03-26 00:00:00 |  | 68984.5 | 0 | 68984.5
2018-04-02 00:00:00 |  | 236641.3 | 48901.3 | 285542.6
2018-04-09 00:00:00 |  | 0 | 59317.2 | 59317.2
2018-04-16 00:00:00 |  | 0 | 0 | 0
2018-04-23 00:00:00 |  | 147904.2 | 0 | 147904.2
2018-04-30 00:00:00 |  | 293146.2 | 0 | 293146.2
2018-05-07 00:00:00 |  | 454955 | 0 | 454955
2018-05-14 00:00:00 |  | 0 | 0 | 0
2018-05-21 00:00:00 |  | 73952.09999999999 | 0 | 73952.09999999999
2018-05-28 00:00:00 |  | 110827.2 | 0 | 110827.2
2018-06-04 00:00:00 |  | 181650.9 | 0 | 181650.9
2018-06-11 00:00:00 |  | 0 | 0 | 0
2018-06-18 00:00:00 |  | 0 | 0 | 0
2018-06-25 00:00:00 |  | 47661.2 | 0 | 47661.2
2018-07-02 00:00:00 |  | 0 |  | 0
2018-07-09 00:00:00 |  | 0 |  | 0
2018-07-16 00:00:00 |  | 49301.4 |  | 49301.4
2018-07-23 00:00:00 |  | 73884.8 |  | 73884.8
Grand Total | 22584377.49 | 5341333.4 | 24558333.321 | 52484044.211