Spreadsheet: 838768d1691391771-how-to-create-a-dynamic-report-report
Sheet: Sheet1

 |  |  |  |  |  |  | Report A
Sales Details |  |  |  |  |  |  | Start: | 2023-03-06 00:00:00
 |  |  |  |  |  |  | End: | 2023-03-12 00:00:00
Date | Transaction# | Department | Unit | Sales | Seller ID |  | Rank | Seller ID | Total Sales | Total Transactions | Total Units
2023-03-01 00:00:00 | 7870 | Sony Camera | 1 | 166.9 | 106 |  | 1
2023-03-01 00:00:00 | 7871 | [NAME] | -1 | -147.9 | 101 |  | 2
2023-03-01 00:00:00 | 7871 | [NAME] | 1 | 147.9 | 101 |  | 3
2023-03-01 00:00:00 | 7902 | Nikon Camera | 1 | 159.9 | 105 |  | 4
2023-03-01 00:00:00 | 7902 | Canon Camera | 1 | 156.9 | 105 |  | 5
2023-03-01 00:00:00 | 7904 | Sony Camera | 1 | 158.51 | 106 |  | 6
2023-03-01 00:00:00 | 7906 | [NAME] | 1 | 202.06 | 105 |  | 7
2023-03-01 00:00:00 | 7908 | Sony Camera | 1 | 161.2 | 104 |  | 8
2023-03-01 00:00:00 | 7910 | [NAME] | -1 | -145.91 | 103 |  | 9
2023-03-01 00:00:00 | 7910 | [NAME] | -1 | -197.21 | 103 |  | 10
2023-03-01 00:00:00 | 7911 | [NAME] | 1 | 145.91 | 103 |  | 11
2023-03-01 00:00:00 | 7911 | Canon Camera | 1 | 197.21 | 103 |  | 12 |  |  | 1 | 1
2023-03-01 00:00:00 | 7912 | [NAME] | 1 | 164.06 | 106
2023-03-02 00:00:00 | 7982 | [NAME] | 1 | 176.51 | 108
2023-03-02 00:00:00 | 7987 | [NAME] | 1 | 129.9 | 104 |  | Report B
2023-03-02 00:00:00 | 7987 | Nikon Camera | 1 | 139.9 | 104
2023-03-02 00:00:00 | 7988 | [NAME] | 1 | 167.51 | 108 |  | Date | Total Sales | Total Transactions | Total Units
2023-03-02 00:00:00 | 7988 | [NAME] | 1 | 140.51 | 108 |  | 2023-03-01 00:00:00 | 1169.53 | 9 | 7
2023-03-02 00:00:00 | 7989 | Nikon Camera | 1 | 189.7 | 104 |  | 2023-03-02 00:00:00 | 944.03 | 4 | 6
2023-03-03 00:00:00 | 8039 | [NAME] | 1 | 149.9 | 102 |  | 2023-03-03 00:00:00 | 2101.25 | 12 | 12
2023-03-03 00:00:00 | 8040 | [NAME] | 1 | 195.4 | 110 |  | 2023-03-04 00:00:00 | 969.18 | 6 | 6
2023-03-03 00:00:00 | 8044 | [NAME] | 1 | 189.7 | 110 |  | 2023-03-05 00:00:00 | 1527.56 | 6 | 9
2023-03-03 00:00:00 | 8047 | Sony Camera | -1 | -166.9 | 112 |  | 2023-03-06 00:00:00 | 980.62 | 6 | 6
2023-03-03 00:00:00 | 8047 | Sony Camera | 1 | 170.7 | 112 |  | 2023-03-07 00:00:00 | 2220.6 | 12 | 13
2023-03-03 00:00:00 | 8048 | [NAME] | 1 | 189.7 | 102 |  | 2023-03-08 00:00:00 | 2410.67 | 8 | 14
2023-03-03 00:00:00 | 8049 | [NAME] | 1 | 163.91 | 106 |  | 2023-03-09 00:00:00 | 1488.51 | 9 | 9
2023-03-03 00:00:00 | 8050 | Sony Camera | -1 | -161.2 | 112 |  | 2023-03-10 00:00:00 | 1317.73 | 7 | 8
2023-03-03 00:00:00 | 8050 | Sony Camera | 1 | 170.7 | 112 |  | 2023-03-11 00:00:00 | 826.6199999999999 | 4 | 5
2023-03-03 00:00:00 | 8056 | Sony Camera | 1 | 167.51 | 109 |  | 2023-03-12 00:00:00 | 546.3199999999999 | 3 | 3
2023-03-03 00:00:00 | 8056 | FujiFilm Camera | 1 | 163.52 | 109 |  | 2023-03-13 00:00:00 | 1105.13 | 4 | 7
2023-03-03 00:00:00 | 8056 | Sony Camera | 1 | 208.91 | 109 |  | 2023-03-14 00:00:00 | 761.02 | 5 | 5
2023-03-03 00:00:00 | 8078 | Canon Camera | 1 | 193.9 | 102
2023-03-03 00:00:00 | 8078 | [NAME] | 1 | 139.9 | 102
2023-03-03 00:00:00 | 8081 | [NAME] | 1 | 170.7 | 102 |  | Note:
2023-03-03 00:00:00 | 8085 | [NAME] | -1 | -166.9 | 104 |  | Department |  | Remark
2023-03-03 00:00:00 | 8085 | Canon Camera | 1 | 173.9 | 104 |  | Credit Off |  | Need to exclude from sale
2023-03-03 00:00:00 | 8116 | [NAME] | 1 | 147.9 | 106 |  | Free cleaning kits |  | Need to exclude from sale
2023-03-04 00:00:00 | 8127 | Sony Camera | 1 | 158.51 | 109 |  | Free Bag |  | Need to exclude from sale
2023-03-04 00:00:00 | 8128 | Polaroid Camera | 1 | 156.9 | 101 |  | Paper bag |  | Need to exclude from sale
2023-03-04 00:00:00 | 8197 | Nikon Camera | 1 | 169.9 | 106
2023-03-04 00:00:00 | 8200 | [NAME] | 1 | 145.91 | 110
2023-03-04 00:00:00 | 8202 | Sony Camera | 1 | 164.06 | 104
2023-03-04 00:00:00 | 8208 | [NAME] | 1 | 173.9 | 106
2023-03-05 00:00:00 | 8287 | [NAME] | 1 | 159.9 | 105
2023-03-05 00:00:00 | 8289 | [NAME] | 1 | 147.9 | 103
2023-03-05 00:00:00 | 8289 | Nikon Camera | 1 | 170.7 | 103
2023-03-05 00:00:00 | 8289 | FujiFilm Camera | 1 | 176.4 | 103
2023-03-05 00:00:00 | 8299 | Sony Camera | 1 | 164.06 | 106
2023-03-05 00:00:00 | 8300 | [NAME] | 1 | 193.9 | 102
2023-03-05 00:00:00 | 8300 | Canon Camera | 1 | 173.9 | 102
2023-03-05 00:00:00 | 8305 | [NAME] | 1 | 173.9 | 106
2023-03-05 00:00:00 | 8309 | Nikon Camera | 1 | 166.9 | 102
2023-03-06 00:00:00 | 8318 | Sony Camera | 1 | 176.4 | 101
2023-03-06 00:00:00 | 8319 | [NAME] | 1 | 135.83 | 108
2023-03-06 00:00:00 | 8347 | [NAME] | 1 | 163.9 | 107
2023-03-06 00:00:00 | 8347 | Sony Camera | 1 | 163.9 | 107
2023-03-06 00:00:00 | 8348 | [NAME] | 1 | 180.2 | 109
2023-03-06 00:00:00 | 8352 | Sony Camera | -1 | -158.51 | 112
2023-03-06 00:00:00 | 8352 | [NAME] | 1 | 155 | 112
2023-03-06 00:00:00 | 8352 | Credit Off | 1 | 3.509999999999991 | 112
2023-03-06 00:00:00 | 8378 | [NAME] | 1 | 163.9 | 102
2023-03-07 00:00:00 | 8406 | [NAME] | 1 | 170.7 | 112
2023-03-07 00:00:00 | 8406 | [NAME] | 1 | 183.06 | 112
2023-03-07 00:00:00 | 8454 | [NAME] | 1 | 192.56 | 106
2023-03-07 00:00:00 | 8455 | [NAME] | 1 | 166.9 | 109
2023-03-07 00:00:00 | 8456 | Sony Camera | 1 | 154.91 | 108
2023-03-07 00:00:00 | 8457 | Sony Camera | 1 | 157.4 | 112
2023-03-07 00:00:00 | 8459 | Sony Camera | -1 | -154.56 | 108
2023-03-07 00:00:00 | 8459 | Sony Camera | 1 | 154.56 | 108
2023-03-07 00:00:00 | 8503 | [NAME] | 1 | 180.2 | 106
2023-03-07 00:00:00 | 8509 | Sony Camera | 1 | 158.51 | 102
2023-03-07 00:00:00 | 8510 | [NAME] | 1 | 170.7 | 110
2023-03-07 00:00:00 | 8514 | Sony Camera | 1 | 170.7 | 107
2023-03-07 00:00:00 | 8516 | [NAME] | 1 | 183.06 | 106
2023-03-07 00:00:00 | 8519 | [NAME] | 1 | 170.7 | 110
2023-03-07 00:00:00 | 8519 | [NAME] | 1 | 161.2 | 110
2023-03-08 00:00:00 | 8530 | [NAME] | 1 | 170.7 | 112
2023-03-08 00:00:00 | 8530 | [NAME] | 1 | 164.06 | 112
2023-03-08 00:00:00 | 8530 | Free cleaning kits | 1 | 10 | 112
2023-03-08 00:00:00 | 8531 | [NAME] | 1 | 206.9 | 103
2023-03-08 00:00:00 | 8533 | Polaroid Camera | 1 | 170.7 | 103
2023-03-08 00:00:00 | 8533 | Nikon Camera | 1 | 183.06 | 103
2023-03-08 00:00:00 | 8535 | Nikon Camera | 1 | 190.91 | 101
2023-03-08 00:00:00 | 8536 | Sony Camera | 1 | 173.9 | 101
2023-03-08 00:00:00 | 8536 | Polaroid Camera | 1 | 166.9 | 101
2023-03-08 00:00:00 | 8536 | Free Bag | 1 | 0 | 101
2023-03-08 00:00:00 | 8537 | [NAME] | 1 | 150 | 112
2023-03-08 00:00:00 | 8537 | [NAME] | 1 | 170.7 | 112
2023-03-08 00:00:00 | 8538 | Sony Camera | 1 | 181.91 | 108
2023-03-08 00:00:00 | 8539 | Sony Camera | 1 | 158.51 | 101
2023-03-08 00:00:00 | 8539 | Polaroid Camera | 1 | 161.21 | 101
2023-03-08 00:00:00 | 8539 | Nikon Camera | 1 | 161.21 | 101
2023-03-08 00:00:00 | 8539 | Free cleaning kits | 1 | 10 | 101
2023-03-08 00:00:00 | 8539 | Paper bag | 1 | 0 | 101
2023-03-09 00:00:00 | 8674 | Sony Camera | 1 | 161.2 | 106
2023-03-09 00:00:00 | 8675 | [NAME] | 1 | 145.91 | 104
2023-03-09 00:00:00 | 8676 | Sony Camera | -1 | -158.51 | 104
2023-03-09 00:00:00 | 8676 | Sony Camera | 1 | 158.51 | 104
2023-03-09 00:00:00 | 8677 | Sony Camera | 1 | 166.9 | 108
2023-03-09 00:00:00 | 8758 | [NAME] | 1 | 173.9 | 102
2023-03-09 00:00:00 | 8759 | Sony Camera | 1 | 161.2 | 104
2023-03-09 00:00:00 | 8760 | [NAME] | -1 | -209.9 | 106
2023-03-09 00:00:00 | 8760 | [NAME] | 1 | 199.9 | 106
2023-03-09 00:00:00 | 8760 | Credit Off | 1 | 120 | 106
2023-03-09 00:00:00 | 8764 | [NAME] | 1 | 147.52 | 113
2023-03-09 00:00:00 | 8764 | [NAME] | 1 | 169.12 | 113
2023-03-09 00:00:00 | 8768 | [NAME] | 1 | 202.06 | 101
2023-03-09 00:00:00 | 8768 | Sony Camera | 1 | 170.7 | 101
2023-03-10 00:00:00 | 8773 | Sony Camera | 1 | 153.9 | 101
2023-03-10 00:00:00 | 8775 | [NAME] | 1 | 167.51 | 108
2023-03-10 00:00:00 | 8778 | Sony Camera | 1 | 194.51 | 109
2023-03-10 00:00:00 | 8779 | Sony Camera | 1 | 164.06 | 103
2023-03-10 00:00:00 | 8782 | [NAME] | 1 | 135.83 | 103
2023-03-10 00:00:00 | 8867 | [NAME] | 1 | 166.9 | 102
2023-03-10 00:00:00 | 8872 | Sony Camera | 1 | 167.51 | 104
2023-03-10 00:00:00 | 8872 | [NAME] | 1 | 167.51 | 104
2023-03-11 00:00:00 | 8885 | [NAME] | 1 | 164.06 | 113
2023-03-11 00:00:00 | 8886 | Sony Camera | 1 | 170.7 | 109
2023-03-11 00:00:00 | 8888 | [NAME] | 1 | 143.9 | 112
2023-03-11 00:00:00 | 8888 | [NAME] | 1 | 183.9 | 112
2023-03-11 00:00:00 | 8979 | [NAME] | 1 | 164.06 | 105
2023-03-12 00:00:00 | 8989 | [NAME] | 1 | 170.7 | 108
2023-03-12 00:00:00 | 8990 | [NAME] | 1 | 202.06 | 101
2023-03-12 00:00:00 | 8991 | Sony Camera | 1 | 173.56 | 101
2023-03-13 00:00:00 | 9097 | [NAME] | 1 | 133.92 | 108
2023-03-13 00:00:00 | 9097 | [NAME] | 1 | 172.91 | 108
2023-03-13 00:00:00 | 9098 | Sony Camera | 1 | 173.9 | 112
2023-03-13 00:00:00 | 9098 | Sony Camera | 1 | 173.9 | 112
2023-03-13 00:00:00 | 9145 | Sony Camera | 1 | 170.7 | 110
2023-03-13 00:00:00 | 9179 | [NAME] | 1 | 149.9 | 110
2023-03-13 00:00:00 | 9179 | [NAME] | 1 | 129.9 | 110
2023-03-14 00:00:00 | 9190 | Sony Camera | 1 | 157.4 | 101
2023-03-14 00:00:00 | 9195 | Sony Camera | 1 | 166.9 | 108
2023-03-14 00:00:00 | 9199 | [NAME] | 1 | 137.12 | 108
2023-03-14 00:00:00 | 9200 | Sony Camera | 1 | 170.7 | 101
2023-03-14 00:00:00 | 9202 | [NAME] | 1 | 128.9 | 101