Zoho Sheet

Zoho Report

Week 2 Task 4 Spreadsheet

Monday, August 6, 2012

SQL Tables

SELECT month ("Date")  "Month" ,"Region","Product Category","Profit","Profit per Item" FROM "Sales" WHERE "Region" = 'West' AND "Profit">500

link= https://reports.zoho.com/ZDBDataSheetView.cc?OBJID=794004000000006022&STANDALONE=true&privatelink=af1696d31521a08719e5035290bc5a43&ZDB_THEME_NAME=blue&DATATYPESYMBOL=false&REMTOOLBAR=true&SEARCHBOX=true&SHOWHIDEOPT=true

This Query Table is valuable as it will see the profitable product categories for this business in The Western region, which can be compared to the other table's profits.

SELECT "Date","Product Category","Product","Customer Name","Sales","Profit" FROM "Sales" WHERE "Region" = 'East' AND "Profit">500
This Query allows for the comparison in profit

link= https://reports.zoho.com/ZDBDataSheetView.cc?OBJID=794004000000006141&STANDALONE=true&privatelink=7f622c31f6faae3b7d57ce2570499d16&ZDB_THEME_NAME=blue&DATATYPESYMBOL=false&REMTOOLBAR=true&SEARCHBOX=true&SHOWHIDEOPT=true
This Query Table allows for the comparison of profitable product categories(+500) from the Eastern region to the Western region of the other table. One can see which area has more, and how much more profitable categories of items to determine where to focus shipping products.

No comments:

Post a Comment