Task:

List suppliers and their products with total sales.
Include grand total, supplier subtotals, and supplier/product subtotals.
Click here for details on ROLLUP.
 
 94 Records
CompanyName ProductName Total Sales
NULL NULL 1328276.24
ARJUN NULL 163135.00
ARJUN Chartreuse verte 13150.80
ARJUN Côte de Blaye 149984.20
Escargots Nouveaux NULL 6664.75
Escargots Nouveaux Escargots de Bourgogne 6664.75
fff NULL 317123.30
fff Aniseed Syrup 3080.00
fff Boston Crab Meat 19048.30
fff chai_new2 14277.60
fff Chef Anton's Cajun Seasoning 9424.80
fff Flotemysost 20876.50
fff Geitost 1713.50
fff Genen Shouyu 1813.50
fff Grandma's Boysenberry Spread 7345.00
fff Guaraná Fantástica 4782.60
fff Gudbrandsdalsost 24307.20
fff Ikura 22140.20
fff Jack's New England Clam Chowder 9021.10
fff Konbu 5234.40
fff Laughing Lumberjack Lager 2562.00
fff Longlife Tofu 2566.00
fff Louisiana Fiery Hot Pepper Sauce 14019.00
fff Louisiana Hot Spiced Okra 3519.00
fff Northwoods Cranberry Sauce 13760.00
fff Queso Cabrales 13734.00
fff Queso Manchego La Pastora 12866.80
fff Sasquatch Ale 6678.00
fff Scottish Longbreads 9362.50
fff sekar 18559.20
fff Sir Rodney's Marmalade 23635.80
fff Sir Rodney's Scones 9636.00
fff Steeleye Stout 14536.80
fff Teatime Chocolate Biscuits 6159.50
fff Uncle Bob's Organic Dried Pears 22464.00
Forêts d'érables NULL 66266.70
Forêts d'érables Sirop d'érable 16438.80
Forêts d'érables Tarte au sucre 49827.90
Formaggi Fortini s.r.l. NULL 50908.50
Formaggi Fortini s.r.l. Gorgonzola Telino 16172.50
Formaggi Fortini s.r.l. Mascarpone Fabioli 9171.20
Formaggi Fortini s.r.l. Mozzarella di Giovanni 25564.80
Gai pâturage NULL 126582.00
Gai pâturage Camembert Pierrot 50286.00
Gai pâturage Raclette Courdavault 76296.00
G'day, Mate NULL 68152.60
G'day, Mate Filo Mix 3383.80
G'day, Mate Manjimup Dried Apples 43258.60
G'day, Mate Perth Pasties 21510.20
Heli Süßwaren GmbH & Co. KG NULL 40818.00
Heli Süßwaren GmbH & Co. KG Gumbär Gummibärchen 21534.90
Heli Süßwaren GmbH & Co. KG NuNuCa Nuß-Nougat-Creme 4051.60
Heli Süßwaren GmbH & Co. KG Schoggi Schokolade 15231.50
Karkki Oy NULL 29804.00
Karkki Oy Lakkalikööri 16794.00
Karkki Oy Maxilaku 9500.00
Karkki Oy Valkoinen suklaa 3510.00
Leka Trading NULL 44837.80
Leka Trading Gula Malacca 10524.20
Leka Trading Ipoh Coffee 25079.20
Leka Trading Singaporean Hokkien Fried Mee 9234.40
Lyngbysild NULL 10884.50
Lyngbysild prueba 6144.00
Lyngbysild Rogede sild 4740.50
Ma Maison NULL 24633.00
Ma Maison Pâté chinois 19512.00
Ma Maison Tourtière 5121.00
Nord-Ost-Fisch Handelsgesellschaft mbH NULL 14775.54
Nord-Ost-Fisch Handelsgesellschaft mbH Nord-Ost Matjeshering 14775.54
Pakkoda Boys NULL 11971.80
Pakkoda Boys Gustaf's Knäckebröd 7131.60
Pakkoda Boys Tunnbröd 4840.20
Pasta Buttini s.r.l. NULL 52695.00
Pasta Buttini s.r.l. Gnocchi di nonna Alice 45121.20
Pasta Buttini s.r.l. Ravioli Angelo 7573.80
Pavlova, Ltd. NULL 115386.05
Pavlova, Ltd. Alice Mutton 35482.20
Pavlova, Ltd. Carnarvon Tigers 31987.50
Pavlova, Ltd. Outback Lager 11472.00
Pavlova, Ltd. Pavlova 18748.05
Pavlova, Ltd. Vegie-spread 17696.30
Plutzer Lebensmittelgroßmärkte AG NULL 155946.55
Plutzer Lebensmittelgroßmärkte AG Original Frankfurter grüne Soße 9685.00
Plutzer Lebensmittelgroßmärkte AG Rhönbräu Klosterbier 8650.55
Plutzer Lebensmittelgroßmärkte AG Rössle Sauerkraut 26865.60
Plutzer Lebensmittelgroßmärkte AG Thüringer Rostbratwurst 87736.40
Plutzer Lebensmittelgroßmärkte AG Wimmers gute Semmelknödel 23009.00
Svensk Sjöföda AB NULL 21789.80
Svensk Sjöföda AB Gravad lax 3047.20
Svensk Sjöföda AB Inlagd Sill 14542.60
Svensk Sjöföda AB Röd Kaviar 4200.00
Zaanse Snoepfabriek NULL 5901.35
Zaanse Snoepfabriek Chocolade 1542.75
Zaanse Snoepfabriek Zaanse koeken 4358.60
Stay Inspired!
Join other developers and designers who have already signed up for our mailing list.
Terms     Privacy     Licensing       EULA       Sitemap      
© Data & Object Factory, LLC.
Made with    in Austin, Texas.      Vsn 1.3.0