16. Practice Exercises with Answer Hints
16.6 Module 7: PivotTables
- Pivot of sales by City and Platform. Hint: Rows = City, Columns = Platform, Values = Sum of Amount → total 2,870 on the mini dataset.
- Show each city's sales as a % of the grand total. Hint: Value Field Settings › Show Values As › % of Grand Total.
- Group order dates by month and quarter. Hint: right-click a date › Group › Months, Quarters.
- Count distinct customers per city. Hint: tick Add this data to the Data Model › Value Field Settings › Distinct Count.
- Add a calculated field for 5% commission.
Hint: PivotTable Analyze › Calculations › Fields, Items & Sets › Calculated Field
=Amount*0.05. - Show the top 3 cities by sales. Hint: Row Labels filter › Value Filters › Top 10 › 3 Items.
- Connect one City slicer to two pivots. Hint: right-click slicer › Report Connections.
Ravindra Bagale's Tip
Khup students source data madhe navin rows add kartat aani pivot refresh kela tari te disat nahit – karan pivot range var banavla hota, Table var nahi. Nehmi Table var pivot banva aani Data › Refresh All vapra. Pivot madhe Count aala tar column madhe blanks kiwa text numbers aahet – aadhi te clean kara.