Creating Customer Performance Report

Now let’s create the Report

Goto Data Tab > Queries & Connection

Then go to Insert > Pivot Table >

Copy of Copy of class Car def init(self, brand, model) self,brand = brand self,model = model_enhanced.png

Drag dim_customer (customer) & drop to Rows

Drag dim_market (region) & drop to Filters

Drag dim_market (market) & drop to Filters

Drag dim_product (division) & drop to Filters

Now Values

Drag fact_sales_monthly (net_sales_amount) & drop to Values

Drag dim_date (FY) & drop to Columns

Copy of Copy of class Car def init(self, brand, model) self,brand = brand self,model = model (1)_enhanced.png

Now I don’t need the Grand Total column