Product CustomerID Qtr 1 Qtr 2 Qtr 3 Qtr 4
Data
Product Sum of Qtr 1 Sum of Qtr 2 Sum of Qtr 3 Sum of Qtr 4
Alice Mutton $ 2,667.60 $ 4,013.10 $ 4,836.00 $ 6,087.90
Aniseed Syrup $ 544.00 $ 600.00 $ 140.00 $ 440.00
Boston Crab Meat $ 1,768.41 $ 1,978.00 $ 4,412.32 $ 1,656.00
Camembert Pierrot $ 3,182.40 $ 4,683.50 $ 9,579.50 $ 3,060.00
Chef Anton's Cajun Seasoning $ 225.28 $ 2,970.00 $ 1,337.60 $ 682.00
Chef Anton's Gumbo Mix $ - $ - $ 288.22 $ 85.40
Filo Mix $ 187.60 $ 742.00 $ 289.80 $ 904.75
Gorgonzola Telino $ 464.50 $ 3,639.37 $ 515.00 $ 2,681.87
Grandma's Boysenberry Spread $ - $ - $ 1,750.00 $ 750.00
Ipoh Coffee $ 1,398.40 $ 4,496.50 $ 1,196.00 $ 3,979.00
Jack's New England Clam Chowder $ 385.00 $ 1,325.03 $ 1,582.60 $ 1,664.62
Laughing Lumberjack Lager $ - $ 518.00 $ 350.00 $ 42.00
Longlife Tofu $ 488.00 $ - $ - $ 512.50
Louisiana Fiery Hot Pepper Sauce $ 1,347.36 $ 2,750.69 $ 1,375.62 $ 3,899.51
Louisiana Hot Spiced Okra $ 1,509.60 $ 530.40 $ 68.00 $ 850.00
Mozzarella di Giovanni $ 1,390.00 $ 4,488.20 $ 3,027.60 $ 2,697.00
Northwoods Cranberry Sauce $ - $ 1,300.00 $ - $ 2,960.00
Ravioli Angelo $ 499.20 $ 282.75 $ 390.00 $ 984.75
Sasquatch Ale $ 551.60 $ 665.00 $ - $ 890.40
Sir Rodney's Marmalade $ - $ 4,252.50 $ 3,061.80 $ -
Sir Rodney's Scones $ 1,462.00 $ 644.00 $ 1,733.00 $ 1,434.00
Steeleye Stout $ 1,310.40 $ 1,368.00 $ 1,323.00 $ 1,273.50
Teatime Chocolate Biscuits $ 943.89 $ 349.60 $ 841.80 $ 851.46
Uncle Bob's Organic Dried Pears $ 1,084.80 $ 1,575.00 $ 2,700.00 $ 3,826.50
Veggie-spread $ 3,202.87 $ 263.40 $ 842.88 $ 2,590.10
Total Result $ 24,612.91 $ 43,435.04 $ 41,640.74 $ 44,803.26
Data
Product CustomerID Sum of Qtr 1 Sum of Qtr 2 Sum of Qtr 3
Alice Mutton
ANTON $ - $ 702.00 $ -
BERGS $ 312.00 $ - $ -
BOLID $ - $ - $ -
BOTTM $ 1,170.00 $ - $ -
ERNSH $ 1,123.20 $ - $ -
GODOS $ - $ 280.80 $ -
HUNGC $ 62.40 $ - $ -
PICCO $ - $ 1,560.00 $ 936.00
RATTC $ - $ 592.80 $ -
REGGC $ - $ - $ -
SAVEA $ - $ - $ 3,900.00
SEVES $ - $ 877.50 $ -
WHITC $ - $ - $ -
Aniseed Syrup $ 544.00 $ 600.00 $ 140.00
Boston Crab Meat $ 1,768.41 $ 1,978.00 $ 4,412.32
Camembert Pierrot $ 3,182.40 $ 4,683.50 $ 9,579.50
Chef Anton's Cajun Seasoning $ 225.28 $ 2,970.00 $ 1,337.60
Chef Anton's Gumbo Mix $ - $ - $ 288.22
Filo Mix $ 187.60 $ 742.00 $ 289.80
Gorgonzola Telino $ 464.50 $ 3,639.37 $ 515.00
Grandma's Boysenberry Spread $ - $ - $ 1,750.00
Ipoh Coffee $ 1,398.40 $ 4,496.50 $ 1,196.00
Jack's New England Clam Chowder $ 385.00 $ 1,325.03 $ 1,582.60
Laughing Lumberjack Lager $ - $ 518.00 $ 350.00
Longlife Tofu $ 488.00 $ - $ -
Louisiana Fiery Hot Pepper Sauce $ 1,347.36 $ 2,750.69 $ 1,375.62
Louisiana Hot Spiced Okra $ 1,509.60 $ 530.40 $ 68.00
Mozzarella di Giovanni $ 1,390.00 $ 4,488.20 $ 3,027.60
Northwoods Cranberry Sauce $ - $ 1,300.00 $ -
Ravioli Angelo $ 499.20 $ 282.75 $ 390.00
Sasquatch Ale $ 551.60 $ 665.00 $ -
Sir Rodney's Marmalade $ - $ 4,252.50 $ 3,061.80
Sir Rodney's Scones $ 1,462.00 $ 644.00 $ 1,733.00
Steeleye Stout $ 1,310.40 $ 1,368.00 $ 1,323.00
Teatime Chocolate Biscuits $ 943.89 $ 349.60 $ 841.80
Uncle Bob's Organic Dried Pears $ 1,084.80 $ 1,575.00 $ 2,700.00
Veggie-spread $ 3,202.87 $ 263.40 $ 842.88
Total Result $ 24,612.91 $ 43,435.04 $ 41,640.74
Sum of Qtr 4
$ -
$ -
$ 1,170.00
$ -
$ 2,607.15
$ -
$ -
$ -
$ -
$ 741.00
$ 789.75
$ -
$ 780.00
$ 440.00
$ 1,656.00
$ 3,060.00
$ 682.00
$ 85.40
$ 904.75
$ 2,681.87
$ 750.00
$ 3,979.00
$ 1,664.62
$ 42.00
$ 512.50
$ 3,899.51
$ 850.00
$ 2,697.00
$ 2,960.00
$ 984.75
$ 890.40
$ -
$ 1,434.00
$ 1,273.50
$ 851.46
$ 3,826.50
$ 2,590.10
$ 44,803.26
This PivotTable is filtered by the Top 10 selling products in Qtr 1
Data
Product Sum of Qtr 1 Sum of Qtr 2 Sum of Qtr 3 Sum of Qtr 4
Alice Mutton $ 2,667.60 $ 4,013.10 $ 4,836.00 $ 6,087.90
Boston Crab Meat $ 1,768.41 $ 1,978.00 $ 4,412.32 $ 1,656.00
Camembert Pierrot $ 3,182.40 $ 4,683.50 $ 9,579.50 $ 3,060.00
Ipoh Coffee $ 1,398.40 $ 4,496.50 $ 1,196.00 $ 3,979.00
Louisiana Fiery Hot Pepper Sauce $ 1,347.36 $ 2,750.69 $ 1,375.62 $ 3,899.51
Louisiana Hot Spiced Okra $ 1,509.60 $ 530.40 $ 68.00 $ 850.00
Mozzarella di Giovanni $ 1,390.00 $ 4,488.20 $ 3,027.60 $ 2,697.00
Sir Rodney's Scones $ 1,462.00 $ 644.00 $ 1,733.00 $ 1,434.00
Steeleye Stout $ 1,310.40 $ 1,368.00 $ 1,323.00 $ 1,273.50
Veggie-spread $ 3,202.87 $ 263.40 $ 842.88 $ 2,590.10
Total Result $ 19,239.04 $ 25,215.79 $ 28,393.92 $ 27,527.01
