Spreadsheet: 711994d1610012877-how-to-reference-or-find-a-whole-month-in-order-to-find-corresponding-data-test-pivot-example
Sheet: Sheet1

 | date | amount | category | description
 | 2020-01-19 00:00:00 | 793.2157424689843 | manufacuturing | raw materials
 | 2020-01-20 00:00:00 | 465.4523385206585 | office supplies | printer paper
 | 2020-03-19 00:00:00 | 113.7474512908302 | packaging | repairs
 | 2020-03-27 00:00:00 | 503.7659816134972 | office supplies | printer paper
 | 2020-04-04 00:00:00 | 950.0314409277963 | manufacuturing | maintenance
 | 2020-04-12 00:00:00 | 840.6975914146053 | manufacuturing | maintenance |  |  | [NAME]
 | 2020-05-11 00:00:00 | 355.2266935587126 | packaging | supplies
 | 2020-05-14 00:00:00 | 718.5633560767365 | manufacuturing | raw materials |  |  | Sum of amount | Column Labels
 | 2020-05-17 00:00:00 | 321.1895086592373 | manufacuturing | maintenance |  |  |  | Jan | Mar | May | Jun | Jul | Aug | Sep | Oct | Dec | Grand Total
 | 2020-05-24 00:00:00 | 201.2859636629194 | packaging | materials |  |  | Row Labels
 | 2020-05-30 00:00:00 | 611.2702777770525 | manufacuturing | raw materials |  |  | office supplies | 465.4523385206585 | 503.7659816134972 |  |  |  | 590.952710697995 | 884.664530573648 | 573.9819104535738 | 668.4393341495951 | 3687.256806008968
 | 2020-06-03 00:00:00 | 788.1315365219751 | manufacuturing | discardation |  |  | chairs |  |  |  |  |  |  | 884.664530573648 |  |  | 884.664530573648
 | 2020-06-25 00:00:00 | 668.9830376400133 | packaging | installation |  |  | paperclips |  |  |  |  |  |  |  | 573.9819104535738 |  | 573.9819104535738
 | 2020-07-23 00:00:00 | 554.6038568253077 | packaging | new machine |  |  | printer |  |  |  |  |  | 590.952710697995 |  |  |  | 590.952710697995
 | 2020-08-01 00:00:00 | 411.2082630423009 | manufacuturing | raw materials |  |  | printer paper | 465.4523385206585 | 503.7659816134972 |  |  |  |  |  |  |  | 969.2183201341556
 | 2020-08-04 00:00:00 | 590.952710697995 | office supplies | printer |  |  | tacks |  |  |  |  |  |  |  |  | 668.4393341495951 | 668.4393341495951
 | 2020-08-11 00:00:00 | 502.9410172845846 | manufacuturing | raw materials |  |  | packaging |  | 113.7474512908302 | 556.512657221632 | 668.9830376400133 | 554.6038568253077 |  | 1053.026767219597 |  |  | 2946.873770197381
 | 2020-09-04 00:00:00 | 685.275482254 | packaging | supplies |  |  | installation |  |  |  | 668.9830376400133 |  |  |  |  |  | 668.9830376400133
 | 2020-09-11 00:00:00 | 884.664530573648 | office supplies | chairs |  |  | materials |  |  | 201.2859636629194 |  |  |  |  |  |  | 201.2859636629194
 | 2020-09-16 00:00:00 | 367.7512849655972 | packaging | repairs |  |  | new machine |  |  |  |  | 554.6038568253077 |  |  |  |  | 554.6038568253077
 | 2020-10-04 00:00:00 | 544.4386059323381 | manufacuturing | discardation |  |  | repairs |  | 113.7474512908302 |  |  |  |  | 367.7512849655972 |  |  | 481.4987362564275
 | 2020-10-11 00:00:00 | 573.9819104535738 | office supplies | paperclips |  |  | supplies |  |  | 355.2266935587126 |  |  |  | 685.275482254 |  |  | 1040.502175812713
 | 2020-12-07 00:00:00 | 668.4393341495951 | office supplies | tacks |  |  | Grand Total | 465.4523385206585 | 617.5134329043274 | 556.512657221632 | 668.9830376400133 | 554.6038568253077 | 590.952710697995 | 1937.691297793245 | 573.9819104535738 | 668.4393341495951 | 6634.130576206349
 | 2020-12-15 00:00:00 | 159.2853240589621 | manufacuturing | raw materials
 | 2020-12-17 00:00:00 | 387.9078428187544 | manufacuturing | machine maintenance
 | 2020-12-21 00:00:00 | 776.0952514018581 | manufacuturing | maintenance