Task:

List suppliers and their products with total sales.
Include grandtotals, and subtotals for each combination of suppliers and products.
Click here for details on CUBE.
 
 168 Records
CompanyName ProductName Total Sales
NULL NULL 1328276.24
NULL Alice Mutton 35482.20
NULL Aniseed Syrup 3080.00
NULL Boston Crab Meat 19048.30
NULL Camembert Pierrot 50286.00
NULL Carnarvon Tigers 31987.50
NULL chai_new2 14277.60
NULL Chartreuse verte 13150.80
NULL Chef Anton's Cajun Seasoning 9424.80
NULL Chocolade 1542.75
NULL Côte de Blaye 149984.20
NULL Escargots de Bourgogne 6664.75
NULL Filo Mix 3383.80
NULL Flotemysost 20876.50
NULL Geitost 1713.50
NULL Genen Shouyu 1813.50
NULL Gnocchi di nonna Alice 45121.20
NULL Gorgonzola Telino 16172.50
NULL Grandma's Boysenberry Spread 7345.00
NULL Gravad lax 3047.20
NULL Guaraná Fantástica 4782.60
NULL Gudbrandsdalsost 24307.20
NULL Gula Malacca 10524.20
NULL Gumbär Gummibärchen 21534.90
NULL Gustaf's Knäckebröd 7131.60
NULL Ikura 22140.20
NULL Inlagd Sill 14542.60
NULL Ipoh Coffee 25079.20
NULL Jack's New England Clam Chowder 9021.10
NULL Konbu 5234.40
NULL Lakkalikööri 16794.00
NULL Laughing Lumberjack Lager 2562.00
NULL Longlife Tofu 2566.00
NULL Louisiana Fiery Hot Pepper Sauce 14019.00
NULL Louisiana Hot Spiced Okra 3519.00
NULL Manjimup Dried Apples 43258.60
NULL Mascarpone Fabioli 9171.20
NULL Maxilaku 9500.00
NULL Mozzarella di Giovanni 25564.80
NULL Nord-Ost Matjeshering 14775.54
NULL Northwoods Cranberry Sauce 13760.00
NULL NuNuCa Nuß-Nougat-Creme 4051.60
NULL Original Frankfurter grüne Soße 9685.00
NULL Outback Lager 11472.00
NULL Pâté chinois 19512.00
NULL Pavlova 18748.05
NULL Perth Pasties 21510.20
NULL prueba 6144.00
NULL Queso Cabrales 13734.00
NULL Queso Manchego La Pastora 12866.80
NULL Raclette Courdavault 76296.00
NULL Ravioli Angelo 7573.80
NULL Rhönbräu Klosterbier 8650.55
NULL Röd Kaviar 4200.00
NULL Rogede sild 4740.50
NULL Rössle Sauerkraut 26865.60
NULL Sasquatch Ale 6678.00
NULL Schoggi Schokolade 15231.50
NULL Scottish Longbreads 9362.50
NULL sekar 18559.20
NULL Singaporean Hokkien Fried Mee 9234.40
NULL Sir Rodney's Marmalade 23635.80
NULL Sir Rodney's Scones 9636.00
NULL Sirop d'érable 16438.80
NULL Steeleye Stout 14536.80
NULL Tarte au sucre 49827.90
NULL Teatime Chocolate Biscuits 6159.50
NULL Thüringer Rostbratwurst 87736.40
NULL Tourtière 5121.00
NULL Tunnbröd 4840.20
NULL Uncle Bob's Organic Dried Pears 22464.00
NULL Valkoinen suklaa 3510.00
NULL Vegie-spread 17696.30
NULL Wimmers gute Semmelknödel 23009.00
NULL Zaanse koeken 4358.60
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