Ravindra BagaleCourses & study guides

7. PivotTables and PivotCharts

7.7 Sorting, Filtering and Top 10

By Last updated:

Steps in Excel

  1. Sort by value: right-click any Sum of Amount cell › Sort › Sort Largest to Smallest.
  2. Manual order: drag an item label up/down, or type an item name over another label.
  3. Label filter: ▾ next to Row Labels › Label Filters › Begins With… Na.
  4. Top 10: ▾ › Value Filters › Top 10… › Top 5 Items by Sum of Amount › OK.
  5. Report filter: drag Status to Filters › choose Delivered. PivotTable Analyze › PivotTable › Options ▾ › Show Report Filter Pages… creates one sheet per filter item (e.g. one per city).
  6. Clear: PivotTable Analyze › Actions › Clear › Clear Filters.

Worked example. "Top 5 products by sales" (a question reported in interviews – see Module 18): Rows = Product, Values = Sum of Amount, Value Filter Top 5, sorted largest to smallest. Nashik grapes and Nagpur oranges usually lead in season.

Ravindra Bagale's Tip

Top 10 filter lavlyavar Grand Total fakt dakhavlelya 5 cha asto ka sagalyancha? Default madhe to filtered items cha asto – khup students ha total "sagla sales" mhanun report kartat. Grand total che label spasht liha kiwa vegla total dakhva. Ani Top N sathi aadhi sort pan kara, nahitar list alphabetical disate.

Practice task

Show the top 3 areas by delivered sales for each platform, sorted largest first. Use Show Report Filter Pages to create one sheet per city.