1 Use the data on sheet 'Pivot Data' to create Pivot Tables (for each of following): Pivot Tables can be on separate sheets on in this sheet Clearly label your pivot tables 1.a Prepare a report that shows both the Total Amount and Number of each Product/Service types (show all types) 1.b Prepare a report that compares all dates (show qtr's) for only fuels types (Furnace Oil & Propane) Include both Qty and Amount Include a slicer for Years 1.c Prepare a report that compares all years (in colums) Include Amount Include a slicer for Product/Service type Clearly label your pivot tables Remember Formatting... Price Amount Date Product/Service Qty (Excluding Tax and (Includes Taxes) Rebate) 2022-11-30 Service Invoice 2022-11-17 Furnace Oil 2.5 133.5 $74.95 $187.38 $1.78 $249.38 2022-11-17 Service Invoice 1.5 $74.95 $129.29 2022-10-31 Protection Plan $0.00 $29.22 2022-10-17 Service Invoice $74.95 $86.20 2022-10-17 Propane 0.01 $0.00 $0.00 2022-09-30 Protection Plan $0.00 $29.22 2022-09-12 Furnace Oil 261.1 $1.67 $457.57 2022-08-31 Protection Plan $0.00 $29.22 2022-06-20 Furnace Oil 0.01 $0.00 $0.00 2022-05-10 Propane 214.1 $1.40 $317.21 2022-04-18 Furnace Oil 233.6 $1.86 $455.97 2022-03-02 Propane 417.2 $1.34 $591.83 2022-03-01 Furnace Oil 359.7 $1.40 $528.38 2022-01-26 Furnace Oil 300.3 $1.31 $412.74 2021-12-31 Furnace Oil 265.3 $1.25 $347.92 2021-12-29 Propane 217.1 $1.18 $271.49 2021-12-29 Propane 0.01 $0.00 $0.00 2021-11-25 Furnace Oil 231.1 $1.24 $300.65 2021-11-22 Propane 0.01 $0.00 $0.00 2021-11-19 Service Invoice 5 $74.95 $430.96 ...end 2021-10-18 Propane 209.5 $1.07 $237.79 2021-09-27 Furnace Oil 510.9 $1.07 $573.45 2021-07-31 Protection Plan $0.00 $29.22 2021-07-20 Propane 0.01 $0.00 $0.00 2021-04-30 Protection Plan $0.00 $29.22 2021-04-28 Furnace Oil 362.2 $1.05 $398.94 2021-03-31 Protection Plan 0 $0.00 $29.22 2021-03-23 Propane 145 $0.95 $145.44 2021-03-01 Furnace Oil 376.6 $1.01 $398.99 2021-02-28 Protection Plan $0.00 $29.22 2021-01-31 Protection Plan $0.00 $29.22 2021-01-26 Propane 318.7 $0.95 $319.65 2021-01-07 Furnace Oil 427.4 $0.89 $398.95 2020-12-31 Protection Plan 0 $0.00 $26.35 2020-12-18 Service Invoice 3 $69.95 $241.33 2020-12-02 Propane 0.01 $0.00 $0.00 2020-11-30 Protection Plan $0.00 $26.35 2020-11-03 Furnace Oil 461.6 $0.82 $396.95 2020-10-31 Protection Plan $0.00 $26.35 2020-10-05 Propane 315.5 $0.95 $316.44 2020-09-15 Service Invoice $69.95 $80.44 2020-05-21 Furnace Oil 407.7 $0.70 $299.23 2020-05-11 Propane 165 $0.95 $164.93 2020-03-16 Furnace Oil 418 $0.91 $398.95 2020-03-13 Propane 229.3 $0.95 $228.56 2020-02-07 Furnace Oil 348.9 $1.09 $398.94 2020-01-13 Furnace Oil 348.9 $1.09 $398.94 2020-01-06 Propane 121.3 $0.95 $120.90