Building a view to show

1.Build a view to show profit by states. Create an extract to filtered New York state with date rolled up to year, and hide unused fields. Then revise your extract to include the city field.

1. Build a view that shows a company’s order that were returned. The data source contains separate tables for orders and returns. Join them and then build a bar chart that shows the records that are present in the both tables for each subcategory.

Sample Solution