Sale/Cost/Profit (with Future Cost/Future Profit)

T2.7 - redo

T2.4 - redo

Office Equipment - Hardware

Fazio Payroll

Monday, August 1, 2011

Query Tables

https://reports.zoho.com/ZDBDataSheetView.cc?OBJID=315891000000006057&STANDALONE=true&privatelink=6bd22767f54b58f06f9d800d66afcd63&ZDB_THEME_NAME=blue&DATATYPESYMBOL=false&REMTOOLBAR=true
The first query I created shows the customers of the west sales that are greater than $2000. I also adjusted to show the sales in descending order of sales amounts.
Formula =
select"Customer Name","Product Category","Region","Sales" from "Sales" where "Sales">2000 and "Region" = 'West'
https://reports.zoho.com/ZDBDataSheetView.cc?OBJID=315891000000006169&STANDALONE=true&privatelink=55764c81f2b75685fa06418d11c95dab&ZDB_THEME_NAME=blue&DATATYPESYMBOL=false&REMTOOLBAR=true
The second query I created shows the customers of the east sales that are greater than $2000. I also adjusted to show the sales in descending order of sales amounts.
Formula = 
select"Customer Name","Product Category","Region","Sales" from "Sales" where "Sales">2000 and "Region" =  'East'
The results showed that although there a higher average amount spent by the east, there were far more customer in the west (that had the minimum $2000 quota).

The graph that I made may not look as fancy as I had hoped but I edited in such detail that would only show east and west, as well as made it so it only took into the number of sales of over $2000.
https://reports.zoho.com/ZDBDataSheetView.cc?OBJID=315891000000004005&STANDALONE=true&privatelink=967e1a127979305d3a0d25f084042fca&ZDB_THEME_NAME=blue&REMTOOLBAR=true&INCLUDETITLE=true&INCLUDEDESC=true

No comments:

Post a Comment