{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Details","PivotTable","Data","GROUPBY","Drill Down Page","Drill Down Page VBA","GROUPBY for VBA Drill Down"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":14,"comments":0,"pivot_tables":1},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Details","index":0,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Alan Murray"]
[]
[null,"LinkedIn:","https://www.linkedin.com/in/alanmurray-computergaga/"]
[null,"Website:","https://computergaga.com/"]
[null,"YouTube:","https://www.youtube.com/computergaga"]
[null,"Advanced Excel Formulas Book","At Amazon"]

{"sheet":"PivotTable","index":1,"n_rows":29,"n_cols":2,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Product Name","Sum of Total Sales"]
["AutoSum Americano",780.71]
["Bold Italic Espresso",2142.2199999999998]
["Ctrl+Club Sandwich",2083.1700000000005]
["Data-Driven Cappuccino",1485.95]
["Excel Earl Grey",2045.0099999999998]
["Excel-Iced Nitro",1862.54]
["Filter Function Flat White",2990.6800000000003]
["Formula Fill Philly Cheesesteak",1657.9800000000002]
["Formula Fudge Brownie",1129.0100000000002]
["Freeze Pane Cold Brew",1024.7900000000002]
["I ❤️ PIVOTBY Hoodie",1710.1399999999999]
["Macro Mocha Muffin",2088.04]
["Pivot Panini",2359.7200000000003]
["Pivot Pie",2145.6600000000003]
["PivotBY Mug",1800.4299999999998]
["Power Query Peppermint Tea",2031.02]
["R1C1 Carrot Cake",2666.1699999999996]
["Row & Column Ristretto",2562.98]
["Spreadsheet Latte ",2514.5400000000004]
["Spreadsheet Master Tote Bag",2379.1799999999998]
["Spreadsheet Shortcake ",832.4]
["SUM Berry Cheesecake",767.35]
["VBA Veggie Wrap",1444.6999999999998]
["VLOOKUP Velvet Cake",2329.0999999999995]
["VLOOKUP Vintage T-Shirt",1576.9699999999998]
["Grand Total",46410.46]

{"sheet":"Data","index":2,"n_rows":301,"n_cols":7,"rows_kept":301,"cut":false,"hidden":false,"merged":[]}
["Date","Year","Quarter","Product Name","Category","Total Units Sold","Total Sales"]
["2024-08-02",2024,"Q3","Ctrl+Club Sandwich","Sandwich",34,296.13]
["2023-02-25",2023,"Q1","Ctrl+Club Sandwich","Sandwich",12,101.25]
["2023-07-25",2023,"Q3","Bold Italic Espresso","Coffee",49,198.82]
["2024-05-11",2024,"Q2","Macro Mocha Muffin","Cakes and Pastry",38,212.3]
["2024-02-26",2024,"Q1","I ❤️ PIVOTBY Hoodie","Merchandise",16,145.74]
["2024-12-26",2024,"Q4","Spreadsheet Master Tote Bag","Merchandise",41,261.41000000000003]
["2024-03-24",2024,"Q1","Bold Italic Espresso","Coffee",43,335.58]
["2024-01-27",2024,"Q1","Macro Mocha Muffin","Cakes and Pastry",2,7.72]
["2024-10-11",2024,"Q4","Ctrl+Club Sandwich","Sandwich",28,83.27]
["2024-08-18",2024,"Q3","Ctrl+Club Sandwich","Sandwich",18,89.45]
["2024-12-01",2024,"Q4","Formula Fill Philly Cheesesteak","Sandwich",10,25.49]
["2023-08-04",2023,"Q3","Data-Driven Cappuccino","Coffee",20,110.28]
["2024-03-08",2024,"Q1","Filter Function Flat White","Coffee",41,216.56]
["2023-06-25",2023,"Q2","PivotBY Mug","Merchandise",23,218.13]
["2023-09-19",2023,"Q3","Power Query Peppermint Tea","Tea",19,119.63]
["2024-10-21",2024,"Q4","Excel Earl Grey","Tea",21,125.32]
["2023-02-08",2023,"Q1","VBA Veggie Wrap","Sandwich",37,198.23]
["2023-01-14",2023,"Q1","Spreadsheet Shortcake ","Cakes and Pastry",2,17.489999999999998]
["2024-10-03",2024,"Q4","Formula Fill Philly Cheesesteak","Sandwich",24,170.95]
["2023-11-01",2023,"Q4","Formula Fudge Brownie","Cakes and Pastry",1,9.27]
["2024-07-23",2024,"Q3","Excel Earl Grey","Tea",31,171.96]
["2024-01-08",2024,"Q1","Spreadsheet Master Tote Bag","Merchandise",46,382.61]
["2023-08-13",2023,"Q3","Power Query Peppermint Tea","Tea",41,233.16]
["2023-02-18",2023,"Q1","Spreadsheet Latte ","Coffee",47,332.61]
["2023-11-24",2023,"Q4","PivotBY Mug","Merchandise",33,276.39999999999998]
["2023-01-18",2023,"Q1","AutoSum Americano","Coffee",8,63.03]
["2023-04-17",2023,"Q2","VBA Veggie Wrap","Sandwich",46,434.96]
["2023-10-17",2023,"Q4","Filter Function Flat White","Coffee",2,9.84]
["2024-01-19",2024,"Q1","VLOOKUP Vintage T-Shirt","Merchandise",1,7.14]
["2024-01-12",2024,"Q1","Excel Earl Grey","Tea",34,236.02]
["2024-09-20",2024,"Q3","R1C1 Carrot Cake","Cakes and Pastry",29,144.85]
["2024-07-23",2024,"Q3","SUM Berry Cheesecake","Cakes and Pastry",33,203.68]
["2023-07-24",2023,"Q3","Filter Function Flat White","Coffee",3,29.27]
["2024-03-10",2024,"Q1","Formula Fill Philly Cheesesteak","Sandwich",2,14.37]
["2023-09-03",2023,"Q3","Pivot Pie","Cakes and Pastry",26,256.85000000000002]
["2024-07-24",2024,"Q3","Spreadsheet Latte ","Coffee",13,57.34]
["2023-02-17",2023,"Q1","Spreadsheet Master Tote Bag","Merchandise",17,95.95]
["2024-10-10",2024,"Q4","VBA Veggie Wrap","Sandwich",23,158.16]
["2023-04-27",2023,"Q2","Power Query Peppermint Tea","Tea",6,20.51]
["2024-07-15",2024,"Q3","Formula Fudge Brownie","Cakes and Pastry",16,59.16]
["2024-12-20",2024,"Q4","Spreadsheet Shortcake ","Cakes and Pastry",7,33.92]
["2024-03-07",2024,"Q1","VLOOKUP Vintage T-Shirt","Merchandise",46,255.7]
["2024-11-21",2024,"Q4","PivotBY Mug","Merchandise",13,116.7]
["2024-04-12",2024,"Q2","Spreadsheet Latte ","Coffee",22,181.49]
["2023-07-12",2023,"Q3","VBA Veggie Wrap","Sandwich",2,18.03]
["2024-07-11",2024,"Q3","Formula Fill Philly Cheesesteak","Sandwich",13,121.37]
["2024-01-27",2024,"Q1","Spreadsheet Latte ","Coffee",7,20.260000000000002]
["2024-07-28",2024,"Q3","Spreadsheet Master Tote Bag","Merchandise",26,257.02]
["2023-10-16",2023,"Q4","Pivot Panini","Sandwich",33,108.73]
["2024-02-11",2024,"Q1","Pivot Pie","Cakes and Pastry",14,38.840000000000003]
["2024-09-13",2024,"Q3","Spreadsheet Shortcake ","Cakes and Pastry",20,136.84]
["2024-03-25",2024,"Q1","Spreadsheet Master Tote Bag","Merchandise",42,252.73]
["2023-01-05",2023,"Q1","Power Query Peppermint Tea","Tea",35,324.95999999999998]
["2023-05-06",2023,"Q2","Filter Function Flat White","Coffee",44,431.7]
["2024-11-12",2024,"Q4","Filter Function Flat White","Coffee",34,173.28]
["2023-07-02",2023,"Q3","Power Query Peppermint Tea","Tea",27,231.66]
["2024-02-12",2024,"Q1","Data-Driven Cappuccino","Coffee",13,107.34]
["2024-08-17",2024,"Q3","Spreadsheet Latte ","Coffee",17,161.71]
["2023-05-15",2023,"Q2","VBA Veggie Wrap","Sandwich",41,409.81]
["2024-01-14",2024,"Q1","Filter Function Flat White","Coffee",23,115.56]
["2024-12-09",2024,"Q4","R1C1 Carrot Cake","Cakes and Pastry",33,204.47]
["2023-12-09",2023,"Q4","SUM Berry Cheesecake","Cakes and Pastry",12,56.62]
["2024-02-29",2024,"Q1","AutoSum Americano","Coffee",7,25.45]
["2023-04-01",2023,"Q2","Formula Fudge Brownie","Cakes and Pastry",24,91.56]
["2024-09-05",2024,"Q3","Formula Fill Philly Cheesesteak","Sandwich",26,203.72]
["2024-04-29",2024,"Q2","Pivot Panini","Sandwich",18,173.38]
["2024-08-20",2024,"Q3","Pivot Pie","Cakes and Pastry",28,134.19]
["2023-10-02",2023,"Q4","SUM Berry Cheesecake","Cakes and Pastry",11,35.380000000000003]
["2024-05-18",2024,"Q2","VLOOKUP Velvet Cake","Cakes and Pastry",22,199.07]
["2023-01-28",2023,"Q1","Formula Fill Philly Cheesesteak","Sandwich",16,62.52]
["2023-09-27",2023,"Q3","Spreadsheet Shortcake ","Cakes and Pastry",10,52.14]
["2023-04-03",2023,"Q2","Spreadsheet Latte ","Coffee",7,22.45]
["2023-01-10",2023,"Q1","Bold Italic Espresso","Coffee",37,348.14]
["2023-02-20",2023,"Q1","VLOOKUP Velvet Cake","Cakes and Pastry",46,145.83000000000001]
["2024-07-30",2024,"Q3","Spreadsheet Master Tote Bag","Merchandise",33,312.91000000000003]
["2024-11-19",2024,"Q4","PivotBY Mug","Merchandise",14,104.25]
["2024-06-09",2024,"Q2","R1C1 Carrot Cake","Cakes and Pastry",47,469.47]
["2023-10-20",2023,"Q4","Bold Italic Espresso","Coffee",40,144.5]
["2023-11-20",2023,"Q4","Filter Function Flat White","Coffee",9,86.55]
["2024-06-27",2024,"Q2","AutoSum Americano","Coffee",44,212.01]
["2024-12-28",2024,"Q4","VLOOKUP Vintage T-Shirt","Merchandise",30,93.44]
["2023-02-27",2023,"Q1","Spreadsheet Shortcake ","Cakes and Pastry",13,109.36]
["2024-12-21",2024,"Q4","Row & Column Ristretto","Coffee",31,238.04]
["2023-01-22",2023,"Q1","Formula Fill Philly Cheesesteak","Sandwich",40,130.30000000000001]
["2024-05-14",2024,"Q2","Excel-Iced Nitro","Cold Brew",2,10.31]
["2023-03-12",2023,"Q1","Row & Column Ristretto","Coffee",40,309.60000000000002]
["2024-10-29",2024,"Q4","Filter Function Flat White","Coffee",1,5.28]
["2024-03-03",2024,"Q1","Data-Driven Cappuccino","Coffee",2,15.73]
["2024-06-14",2024,"Q2","Pivot Panini","Sandwich",48,473.16]
["2024-06-10",2024,"Q2","VLOOKUP Velvet Cake","Cakes and Pastry",16,78.41]
["2024-06-27",2024,"Q2","Excel-Iced Nitro","Cold Brew",48,319.89]
["2024-08-27",2024,"Q3","Pivot Pie","Cakes and Pastry",11,40.54]
["2023-10-07",2023,"Q4","Macro Mocha Muffin","Cakes and Pastry",17,132.74]
["2024-10-30",2024,"Q4","Spreadsheet Master Tote Bag","Merchandise",24,206.88]
["2024-09-22",2024,"Q3","Spreadsheet Latte ","Coffee",38,152.65]
["2023-09-01",2023,"Q3","AutoSum Americano","Coffee",44,332.43]
["2024-05-23",2024,"Q2","Spreadsheet Shortcake ","Cakes and Pastry",2,12.4]
["2024-10-08",2024,"Q4","Pivot Panini","Sandwich",38,357.52]
["2024-09-04",2024,"Q3","R1C1 Carrot Cake","Cakes and Pastry",33,110.73]
["2024-01-06",2024,"Q1","Macro Mocha Muffin","Cakes and Pastry",43,345.2]
["2023-04-23",2023,"Q2","Data-Driven Cappuccino","Coffee",14,112.89]
["2024-08-08",2024,"Q3","Freeze Pane Cold Brew","Cold Brew",32,307.10000000000002]
["2023-02-08",2023,"Q1","Ctrl+Club Sandwich","Sandwich",46,205.8]
["2023-07-25",2023,"Q3","I ❤️ PIVOTBY Hoodie","Merchandise",21,128.96]
["2024-06-26",2024,"Q2","Filter Function Flat White","Coffee",12,86.1]
["2023-02-27",2023,"Q1","Formula Fudge Brownie","Cakes and Pastry",38,96.2]
["2024-04-23",2024,"Q2","VLOOKUP Vintage T-Shirt","Merchandise",17,73.08]
["2023-11-30",2023,"Q4","SUM Berry Cheesecake","Cakes and Pastry",24,209.89]
["2023-12-01",2023,"Q4","R1C1 Carrot Cake","Cakes and Pastry",5,17.68]
["2023-04-08",2023,"Q2","Pivot Pie","Cakes and Pastry",9,43.59]
["2024-03-29",2024,"Q1","Row & Column Ristretto","Coffee",1,7.14]
["2024-05-01",2024,"Q2","Power Query Peppermint Tea","Tea",2,15.55]
["2024-05-22",2024,"Q2","Pivot Panini","Sandwich",27,94.14]
["2024-03-02",2024,"Q1","Pivot Panini","Sandwich",1,6.89]
["2023-07-11",2023,"Q3","Filter Function Flat White","Coffee",44,380.72]
["2024-11-26",2024,"Q4","Spreadsheet Master Tote Bag","Merchandise",22,113.84]
["2023-01-05",2023,"Q1","Formula Fudge Brownie","Cakes and Pastry",22,211.87]
["2024-06-08",2024,"Q2","Data-Driven Cappuccino","Coffee",24,76.930000000000007]
["2024-08-02",2024,"Q3","I ❤️ PIVOTBY Hoodie","Merchandise",35,255.35]
["2023-06-20",2023,"Q2","I ❤️ PIVOTBY Hoodie","Merchandise",34,248.37]
["2024-03-29",2024,"Q1","Spreadsheet Latte ","Coffee",43,259.37]
["2024-12-12",2024,"Q4","Spreadsheet Latte ","Coffee",43,115.68]
["2023-09-16",2023,"Q3","Bold Italic Espresso","Coffee",6,54.65]
["2024-01-08",2024,"Q1","VLOOKUP Vintage T-Shirt","Merchandise",5,21.16]
["2023-05-09",2023,"Q2","I ❤️ PIVOTBY Hoodie","Merchandise",8,75.55]
["2023-12-22",2023,"Q4","VLOOKUP Vintage T-Shirt","Merchandise",19,164.17]
["2023-09-27",2023,"Q3","Pivot Pie","Cakes and Pastry",9,82.07]
["2023-08-11",2023,"Q3","SUM Berry Cheesecake","Cakes and Pastry",19,181.61]
["2024-10-20",2024,"Q4","VBA Veggie Wrap","Sandwich",12,45.29]
["2024-07-07",2024,"Q3","Pivot Pie","Cakes and Pastry",49,396.63]
["2024-09-13",2024,"Q3","R1C1 Carrot Cake","Cakes and Pastry",6,29.3]
["2023-09-16",2023,"Q3","Filter Function Flat White","Coffee",47,148.72]
["2023-07-21",2023,"Q3","Formula Fudge Brownie","Cakes and Pastry",36,124.48]
["2023-04-10",2023,"Q2","Power Query Peppermint Tea","Tea",25,87.78]
["2024-01-04",2024,"Q1","PivotBY Mug","Merchandise",21,102.38]
["2023-07-18",2023,"Q3","Pivot Panini","Sandwich",17,114.29]
["2023-03-10",2023,"Q1","Pivot Panini","Sandwich",35,169.11]
["2023-02-23",2023,"Q1","VLOOKUP Vintage T-Shirt","Merchandise",16,128.94]
["2024-08-03",2024,"Q3","Row & Column Ristretto","Coffee",21,191.99]
["2024-10-19",2024,"Q4","Pivot Panini","Sandwich",9,62.49]
["2024-11-09",2024,"Q4","Data-Driven Cappuccino","Coffee",46,231.21]
["2023-12-12",2023,"Q4","Bold Italic Espresso","Coffee",37,125.11]
["2023-01-03",2023,"Q1","Ctrl+Club Sandwich","Sandwich",27,118.44]
["2024-08-14",2024,"Q3","Ctrl+Club Sandwich","Sandwich",30,89.83]
["2023-11-16",2023,"Q4","Spreadsheet Latte ","Coffee",26,132.97]
["2024-11-12",2024,"Q4","SUM Berry Cheesecake","Cakes and Pastry",15,80.17]
["2023-05-12",2023,"Q2","Pivot Panini","Sandwich",23,215.97]
["2023-12-20",2023,"Q4","Ctrl+Club Sandwich","Sandwich",4,18.75]
["2023-06-12",2023,"Q2","Pivot Pie","Cakes and Pastry",44,359.08]
["2024-05-18",2024,"Q2","Pivot Pie","Cakes and Pastry",20,153.31]
["2023-01-22",2023,"Q1","Formula Fill Philly Cheesesteak","Sandwich",7,35.57]
["2024-12-03",2024,"Q4","Spreadsheet Latte ","Coffee",22,189.28]
["2024-10-18",2024,"Q4","Formula Fill Philly Cheesesteak","Sandwich",10,90.23]
["2024-10-20",2024,"Q4","Formula Fill Philly Cheesesteak","Sandwich",14,38.06]
["2023-03-30",2023,"Q1","Macro Mocha Muffin","Cakes and Pastry",3,20.34]
["2024-08-24",2024,"Q3","Formula Fill Philly Cheesesteak","Sandwich",30,76.69]
["2024-09-18",2024,"Q3","Bold Italic Espresso","Coffee",5,18.239999999999998]
["2024-01-24",2024,"Q1","Formula Fill Philly Cheesesteak","Sandwich",44,364.16]
["2024-02-16",2024,"Q1","Formula Fill Philly Cheesesteak","Sandwich",31,269.5]
["2024-05-07",2024,"Q2","Macro Mocha Muffin","Cakes and Pastry",36,139.11000000000001]
["2024-12-21",2024,"Q4","R1C1 Carrot Cake","Cakes and Pastry",47,175.95]
["2024-06-10",2024,"Q2","Excel Earl Grey","Tea",15,53.93]
["2023-02-14",2023,"Q1","Excel-Iced Nitro","Cold Brew",14,80.209999999999994]
["2024-03-08",2024,"Q1","Formula Fudge Brownie","Cakes and Pastry",15,100.73]
["2024-05-03",2024,"Q2","PivotBY Mug","Merchandise",17,65.86]
["2023-08-02",2023,"Q3","VLOOKUP Velvet Cake","Cakes and Pastry",15,105.92]
["2024-12-31",2024,"Q4","VLOOKUP Vintage T-Shirt","Merchandise",11,60.89]
["2024-05-26",2024,"Q2","Freeze Pane Cold Brew","Cold Brew",2,17.36]
["2024-03-19",2024,"Q1","Spreadsheet Latte ","Coffee",26,227.31]
["2023-02-22",2023,"Q1","PivotBY Mug","Merchandise",14,73.599999999999994]
["2023-10-14",2023,"Q4","VLOOKUP Velvet Cake","Cakes and Pastry",15,102.26]
["2024-06-21",2024,"Q2","Row & Column Ristretto","Coffee",6,18.760000000000002]
["2024-11-21",2024,"Q4","AutoSum Americano","Coffee",10,72.400000000000006]
["2024-08-14",2024,"Q3","Pivot Panini","Sandwich",40,155.63]
["2023-02-03",2023,"Q1","I ❤️ PIVOTBY Hoodie","Merchandise",43,134.25]
["2024-10-30",2024,"Q4","PivotBY Mug","Merchandise",8,29.29]
["2023-11-24",2023,"Q4","Spreadsheet Latte ","Coffee",45,197.88]
["2024-12-06",2024,"Q4","Ctrl+Club Sandwich","Sandwich",33,310.76]
["2024-01-30",2024,"Q1","R1C1 Carrot Cake","Cakes and Pastry",47,380.92]
["2023-03-06",2023,"Q1","Excel-Iced Nitro","Cold Brew",1,8.3800000000000008]
["2023-11-23",2023,"Q4","Data-Driven Cappuccino","Coffee",44,137.85]
["2023-01-23",2023,"Q1","Data-Driven Cappuccino","Coffee",17,94.11]
["2023-10-18",2023,"Q4","Row & Column Ristretto","Coffee",47,221.99]
["2023-12-14",2023,"Q4","Row & Column Ristretto","Coffee",20,193.5]
["2023-10-29",2023,"Q4","Row & Column Ristretto","Coffee",28,85.09]
["2023-09-11",2023,"Q3","Pivot Panini","Sandwich",19,73.989999999999995]
["2024-10-11",2024,"Q4","Pivot Panini","Sandwich",23,191.57]
["2023-02-28",2023,"Q1","Excel-Iced Nitro","Cold Brew",11,40.6]
["2023-07-14",2023,"Q3","R1C1 Carrot Cake","Cakes and Pastry",11,106.43]
["2023-04-06",2023,"Q2","Bold Italic Espresso","Coffee",39,277.01]
["2024-01-22",2024,"Q1","R1C1 Carrot Cake","Cakes and Pastry",1,6.57]
["2024-06-12",2024,"Q2","PivotBY Mug","Merchandise",42,121.93]
["2024-07-07",2024,"Q3","Spreadsheet Latte ","Coffee",19,91.46]
["2024-09-07",2024,"Q3","VBA Veggie Wrap","Sandwich",20,108.57]
["2023-11-25",2023,"Q4","Power Query Peppermint Tea","Tea",45,186.57]
["2024-02-15",2024,"Q1","Excel-Iced Nitro","Cold Brew",26,70.84]
["2023-05-14",2023,"Q2","Macro Mocha Muffin","Cakes and Pastry",16,142.19]
["2023-03-02",2023,"Q1","Excel-Iced Nitro","Cold Brew",38,119.06]
["2024-08-10",2024,"Q3","VLOOKUP Velvet Cake","Cakes and Pastry",34,331.41]
["2024-05-12",2024,"Q2","Macro Mocha Muffin","Cakes and Pastry",21,201.54]
["2024-01-08",2024,"Q1","I ❤️ PIVOTBY Hoodie","Merchandise",8,65.36]
["2023-02-24",2023,"Q1","Excel Earl Grey","Tea",35,115.93]
["2023-09-07",2023,"Q3","VLOOKUP Vintage T-Shirt","Merchandise",46,249.11]
["2024-06-29",2024,"Q2","Macro Mocha Muffin","Cakes and Pastry",38,313.92]
["2024-10-29",2024,"Q4","Filter Function Flat White","Coffee",6,30.42]
["2024-02-08",2024,"Q1","R1C1 Carrot Cake","Cakes and Pastry",34,272.69]
["2024-12-29",2024,"Q4","Excel-Iced Nitro","Cold Brew",33,322.27999999999997]
["2023-04-28",2023,"Q2","I ❤️ PIVOTBY Hoodie","Merchandise",30,105.46]
["2024-06-13",2024,"Q2","Macro Mocha Muffin","Cakes and Pastry",8,30.25]
["2024-12-22",2024,"Q4","Power Query Peppermint Tea","Tea",46,445.06]
["2023-12-13",2023,"Q4","Pivot Panini","Sandwich",26,162.85]
["2024-08-30",2024,"Q3","PivotBY Mug","Merchandise",41,301.73]
["2024-05-14",2024,"Q2","VLOOKUP Velvet Cake","Cakes and Pastry",11,81.52]
["2024-02-01",2024,"Q1","Macro Mocha Muffin","Cakes and Pastry",23,201.84]
["2023-08-11",2023,"Q3","PivotBY Mug","Merchandise",25,92.8]
["2023-04-28",2023,"Q2","Filter Function Flat White","Coffee",47,343.63]
["2023-02-13",2023,"Q1","VBA Veggie Wrap","Sandwich",17,71.650000000000006]
["2023-06-09",2023,"Q2","Excel Earl Grey","Tea",9,74.31]
["2023-07-14",2023,"Q3","Row & Column Ristretto","Coffee",27,202.37]
["2024-02-03",2024,"Q1","Excel-Iced Nitro","Cold Brew",49,235.6]
["2024-12-11",2024,"Q4","Ctrl+Club Sandwich","Sandwich",49,243.7]
["2024-06-25",2024,"Q2","Row & Column Ristretto","Coffee",30,151.5]
["2023-03-19",2023,"Q1","Pivot Pie","Cakes and Pastry",43,181.7]
["2024-10-15",2024,"Q4","Macro Mocha Muffin","Cakes and Pastry",37,217.78]
["2024-02-25",2024,"Q1","Row & Column Ristretto","Coffee",15,102.58]
["2023-08-31",2023,"Q3","Pivot Pie","Cakes and Pastry",48,218.15]
["2023-04-10",2023,"Q2","Data-Driven Cappuccino","Coffee",11,58.17]
["2023-04-19",2023,"Q2","Data-Driven Cappuccino","Coffee",26,170.75]
["2024-06-25",2024,"Q2","Bold Italic Espresso","Coffee",36,147.99]
["2024-09-09",2024,"Q3","Excel Earl Grey","Tea",10,72.41]
["2024-05-13",2024,"Q2","Row & Column Ristretto","Coffee",18,85.31]
["2023-01-27",2023,"Q1","Formula Fudge Brownie","Cakes and Pastry",7,63.09]
["2024-08-05",2024,"Q3","Freeze Pane Cold Brew","Cold Brew",5,13.38]
["2024-08-27",2024,"Q3","Pivot Pie","Cakes and Pastry",29,240.71]
["2023-10-02",2023,"Q4","Filter Function Flat White","Coffee",13,123.73]
["2024-03-01",2024,"Q1","VLOOKUP Velvet Cake","Cakes and Pastry",32,159.55000000000001]
["2024-09-19",2024,"Q3","Power Query Peppermint Tea","Tea",46,284.45999999999998]
["2024-06-02",2024,"Q2","Formula Fudge Brownie","Cakes and Pastry",24,221.35]
["2024-12-10",2024,"Q4","AutoSum Americano","Coffee",3,16.47]
["2024-05-17",2024,"Q2","PivotBY Mug","Merchandise",42,297.36]
["2024-11-09",2024,"Q4","Ctrl+Club Sandwich","Sandwich",40,365.17]
["2024-09-13",2024,"Q3","Spreadsheet Master Tote Bag","Merchandise",5,21.37]
["2023-05-20",2023,"Q2","Excel-Iced Nitro","Cold Brew",8,75.510000000000005]
["2024-11-09",2024,"Q4","Spreadsheet Master Tote Bag","Merchandise",7,47.73]
["2024-10-07",2024,"Q4","Bold Italic Espresso","Coffee",5,37.770000000000003]
["2024-05-09",2024,"Q2","VLOOKUP Vintage T-Shirt","Merchandise",11,63.58]
["2023-10-25",2023,"Q4","Spreadsheet Master Tote Bag","Merchandise",13,90.06]
["2023-02-12",2023,"Q1","Excel Earl Grey","Tea",18,52.79]
["2024-12-14",2024,"Q4","Spreadsheet Latte ","Coffee",11,35.74]
["2023-01-30",2023,"Q1","Bold Italic Espresso","Coffee",15,136.26]
["2024-01-18",2024,"Q1","Excel Earl Grey","Tea",10,87.86]
["2024-11-27",2024,"Q4","Filter Function Flat White","Coffee",44,427.75]
["2024-10-12",2024,"Q4","Formula Fudge Brownie","Cakes and Pastry",14,122.38]
["2024-11-25",2024,"Q4","Excel Earl Grey","Tea",32,284.12]
["2024-09-28",2024,"Q3","VLOOKUP Velvet Cake","Cakes and Pastry",46,320.31]
["2023-02-03",2023,"Q1","Macro Mocha Muffin","Cakes and Pastry",27,123.11]
["2024-09-23",2024,"Q3","Spreadsheet Master Tote Bag","Merchandise",42,336.67]
["2024-12-14",2024,"Q4","I ❤️ PIVOTBY Hoodie","Merchandise",22,57.6]
["2024-07-13",2024,"Q3","Spreadsheet Latte ","Coffee",25,214.78]
["2023-11-09",2023,"Q4","Excel-Iced Nitro","Cold Brew",15,136.68]
["2023-01-24",2023,"Q1","I ❤️ PIVOTBY Hoodie","Merchandise",39,215.21]
["2023-05-21",2023,"Q2","Freeze Pane Cold Brew","Cold Brew",14,116.6]
["2024-11-20",2024,"Q4","I ❤️ PIVOTBY Hoodie","Merchandise",40,278.29000000000002]
["2023-02-23",2023,"Q1","VLOOKUP Velvet Cake","Cakes and Pastry",17,154.74]
["2024-05-26",2024,"Q2","Bold Italic Espresso","Coffee",36,318.14999999999998]
["2023-09-22",2023,"Q3","Spreadsheet Latte ","Coffee",12,57.76]
["2024-01-10",2024,"Q1","Excel Earl Grey","Tea",18,117.44]
["2024-10-27",2024,"Q4","Spreadsheet Shortcake ","Cakes and Pastry",24,230.9]
["2023-08-03",2023,"Q3","VLOOKUP Vintage T-Shirt","Merchandise",44,307.58]
["2024-01-14",2024,"Q1","Row & Column Ristretto","Coffee",34,129.55000000000001]
["2024-01-10",2024,"Q1","Excel-Iced Nitro","Cold Brew",25,131.56]
["2024-07-17",2024,"Q3","R1C1 Carrot Cake","Cakes and Pastry",42,179.66]
["2023-09-28",2023,"Q3","R1C1 Carrot Cake","Cakes and Pastry",46,218.59]
["2024-03-01",2024,"Q1","Power Query Peppermint Tea","Tea",29,81.680000000000007]
["2023-05-12",2023,"Q2","R1C1 Carrot Cake","Cakes and Pastry",19,149.01]
["2023-03-14",2023,"Q1","Excel Earl Grey","Tea",6,18.7]
["2023-11-28",2023,"Q4","Freeze Pane Cold Brew","Cold Brew",46,455.68]
["2024-01-08",2024,"Q1","Freeze Pane Cold Brew","Cold Brew",36,114.67]
["2023-07-25",2023,"Q3","Formula Fudge Brownie","Cakes and Pastry",3,28.92]
["2024-05-28",2024,"Q2","VLOOKUP Vintage T-Shirt","Merchandise",44,152.18]
["2024-02-04",2024,"Q1","Data-Driven Cappuccino","Coffee",43,370.69]
["2024-08-05",2024,"Q3","Excel Earl Grey","Tea",49,438.28]
["2023-01-22",2023,"Q1","Spreadsheet Shortcake ","Cakes and Pastry",16,142.77000000000001]
["2024-10-11",2024,"Q4","VLOOKUP Velvet Cake","Cakes and Pastry",33,271.33999999999997]
["2024-11-14",2024,"Q4","R1C1 Carrot Cake","Cakes and Pastry",3,9.2899999999999991]
["2023-12-11",2023,"Q4","Ctrl+Club Sandwich","Sandwich",13,63.76]
["2024-07-15",2024,"Q3","VLOOKUP Velvet Cake","Cakes and Pastry",42,378.74]
["2024-12-27",2024,"Q4","Excel Earl Grey","Tea",49,195.94]
["2024-10-01",2024,"Q4","AutoSum Americano","Coffee",7,58.92]
["2023-08-31",2023,"Q3","Filter Function Flat White","Coffee",42,381.57]
["2024-12-18",2024,"Q4","Excel-Iced Nitro","Cold Brew",28,204.2]
["2023-09-05",2023,"Q3","Excel-Iced Nitro","Cold Brew",5,46.91]
["2024-01-29",2024,"Q1","Excel-Iced Nitro","Cold Brew",7,60.51]
["2023-09-04",2023,"Q3","Spreadsheet Latte ","Coffee",21,63.8]
["2024-11-26",2024,"Q4","Spreadsheet Shortcake ","Cakes and Pastry",10,96.58]
["2024-04-07",2024,"Q2","Row & Column Ristretto","Coffee",42,419.49]
["2023-05-14",2023,"Q2","Row & Column Ristretto","Coffee",29,206.07]
["2024-10-21",2024,"Q4","Formula Fill Philly Cheesesteak","Sandwich",7,55.05]
["2023-08-30",2023,"Q3","R1C1 Carrot Cake","Cakes and Pastry",32,190.56]
["2023-12-26",2023,"Q4","Ctrl+Club Sandwich","Sandwich",31,96.86]

{"sheet":"GROUPBY","index":3,"n_rows":30,"n_cols":3,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Category","Merchandise"]
[]
["Show Details","Product Name","Total Sales"]
[false,{"$f":"_xlfn.GROUPBY(tblSales[Product Name],tblSales[Total Sales],_xleta.SUM)","v":"AutoSum Americano"},780.71]
[false,"Bold Italic Espresso",2142.2199999999998]
[false,"Ctrl+Club Sandwich",2083.1700000000005]
[false,"Data-Driven Cappuccino",1485.95]
[false,"Excel Earl Grey",2045.0099999999998]
[false,"Excel-Iced Nitro",1862.54]
[false,"Filter Function Flat White",2990.6800000000003]
[false,"Formula Fill Philly Cheesesteak",1657.9800000000002]
[false,"Formula Fudge Brownie",1129.0100000000002]
[false,"Freeze Pane Cold Brew",1024.7900000000002]
[false,"I ❤️ PIVOTBY Hoodie",1710.1399999999999]
[false,"Macro Mocha Muffin",2088.04]
[false,"Pivot Panini",2359.7200000000003]
[false,"Pivot Pie",2145.6600000000003]
[true,"PivotBY Mug",1800.4299999999998]
[false,"Power Query Peppermint Tea",2031.02]
[false,"R1C1 Carrot Cake",2666.1699999999996]
[false,"Row & Column Ristretto",2562.98]
[false,"Spreadsheet Latte ",2514.5400000000004]
[false,"Spreadsheet Master Tote Bag",2379.1799999999998]
[false,"Spreadsheet Shortcake ",832.4]
[false,"SUM Berry Cheesecake",767.35]
[false,"VBA Veggie Wrap",1444.6999999999998]
[false,"VLOOKUP Velvet Cake",2329.0999999999995]
[false,"VLOOKUP Vintage T-Shirt",1576.9699999999998]
[null,"Total",46410.459999999985]

{"sheet":"Drill Down Page","index":4,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Product Name",{"$f":"_xlfn.XLOOKUP(TRUE,rngCheckboxes,rngProductNames)","v":"PivotBY Mug"}]
[]
[]
[null,"Date","Year","Quarter","Total Units Sold","Total Sales"]
[null,{"$f":"_xlfn._xlws.FILTER(_xlfn.CHOOSECOLS(tblSales[],MATCH(B5:F5,tblSales[#Headers],0)),tblSales[Product Name]=_xlfn.XLOOKUP(TRUE,rngCheckboxes,rngProductNames),\"No checked boxes\")","v":"2023-06-25"},2023,"Q2",23,218.13]
[null,"2023-11-24",2023,"Q4",33,276.39999999999998]
[null,"2024-11-21",2024,"Q4",13,116.7]
[null,"2024-11-19",2024,"Q4",14,104.25]
[null,"2024-01-04",2024,"Q1",21,102.38]
[null,"2024-05-03",2024,"Q2",17,65.86]
[null,"2023-02-22",2023,"Q1",14,73.599999999999994]
[null,"2024-10-30",2024,"Q4",8,29.29]
[null,"2024-06-12",2024,"Q2",42,121.93]
[null,"2024-08-30",2024,"Q3",41,301.73]
[null,"2023-08-11",2023,"Q3",25,92.8]
[null,"2024-05-17",2024,"Q2",42,297.36]

{"sheet":"Drill Down Page VBA","index":5,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Product Name","Formula Fill Philly Cheesesteak"]
[]
[null,"Date","Year","Quarter","Product Name","Category","Total Units Sold","Total Sales"]
[null,{"$f":"_xlfn._xlws.FILTER(tblSales[],tblSales[Product Name]=C2,\"No product specified\")","v":"2024-12-01"},2024,"Q4","Formula Fill Philly Cheesesteak","Sandwich",10,25.49]
[null,"2024-10-03",2024,"Q4","Formula Fill Philly Cheesesteak","Sandwich",24,170.95]
[null,"2024-03-10",2024,"Q1","Formula Fill Philly Cheesesteak","Sandwich",2,14.37]
[null,"2024-07-11",2024,"Q3","Formula Fill Philly Cheesesteak","Sandwich",13,121.37]
[null,"2024-09-05",2024,"Q3","Formula Fill Philly Cheesesteak","Sandwich",26,203.72]
[null,"2023-01-28",2023,"Q1","Formula Fill Philly Cheesesteak","Sandwich",16,62.52]
[null,"2023-01-22",2023,"Q1","Formula Fill Philly Cheesesteak","Sandwich",40,130.30000000000001]
[null,"2023-01-22",2023,"Q1","Formula Fill Philly Cheesesteak","Sandwich",7,35.57]
[null,"2024-10-18",2024,"Q4","Formula Fill Philly Cheesesteak","Sandwich",10,90.23]
[null,"2024-10-20",2024,"Q4","Formula Fill Philly Cheesesteak","Sandwich",14,38.06]
[null,"2024-08-24",2024,"Q3","Formula Fill Philly Cheesesteak","Sandwich",30,76.69]
[null,"2024-01-24",2024,"Q1","Formula Fill Philly Cheesesteak","Sandwich",44,364.16]
[null,"2024-02-16",2024,"Q1","Formula Fill Philly Cheesesteak","Sandwich",31,269.5]
[null,"2024-10-21",2024,"Q4","Formula Fill Philly Cheesesteak","Sandwich",7,55.05]

{"sheet":"GROUPBY for VBA Drill Down","index":6,"n_rows":28,"n_cols":3,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Product Name","Total Sales"]
[null,{"$f":"_xlfn.GROUPBY(tblSales[Product Name],tblSales[Total Sales],_xleta.SUM)","v":"AutoSum Americano"},780.71]
[null,"Bold Italic Espresso",2142.2199999999998]
[null,"Ctrl+Club Sandwich",2083.1700000000005]
[null,"Data-Driven Cappuccino",1485.95]
[null,"Excel Earl Grey",2045.0099999999998]
[null,"Excel-Iced Nitro",1862.54]
[null,"Filter Function Flat White",2990.6800000000003]
[null,"Formula Fill Philly Cheesesteak",1657.9800000000002]
[null,"Formula Fudge Brownie",1129.0100000000002]
[null,"Freeze Pane Cold Brew",1024.7900000000002]
[null,"I ❤️ PIVOTBY Hoodie",1710.1399999999999]
[null,"Macro Mocha Muffin",2088.04]
[null,"Pivot Panini",2359.7200000000003]
[null,"Pivot Pie",2145.6600000000003]
[null,"PivotBY Mug",1800.4299999999998]
[null,"Power Query Peppermint Tea",2031.02]
[null,"R1C1 Carrot Cake",2666.1699999999996]
[null,"Row & Column Ristretto",2562.98]
[null,"Spreadsheet Latte ",2514.5400000000004]
[null,"Spreadsheet Master Tote Bag",2379.1799999999998]
[null,"Spreadsheet Shortcake ",832.4]
[null,"SUM Berry Cheesecake",767.35]
[null,"VBA Veggie Wrap",1444.6999999999998]
[null,"VLOOKUP Velvet Cake",2329.0999999999995]
[null,"VLOOKUP Vintage T-Shirt",1576.9699999999998]
[null,"Total",46410.459999999985]