Skip to main content
≡
Sign in
Your cart
Pearson

The Microsoft Press Store by Pearson

  • Topics
    • AI & Machine Learning
    • Azure
    • Certification & Training
    • Data Analytics & Excel
    • Microsoft Office
    • Windows
    • Programming
    • Software Engineering
    • All topics
  • Formats
    • Books
    • eBooks
    • Practice tests
    • Videos
  • Series
    • Best Practices - Developer
    • Best Practices - IT Pro
    • Business Skills
    • Developer Reference
    • Exam Ref
    • Inside Out
    • MOS Study Guide
    • Step by Step
    • Step by Step for Developers
    • All series
  • Authors
  • Specials
  • More
    • About
    • Contact us
    • Distribution & sales
    • Newsletter
    • Register your book
    • Sample chapters
    • Support
    • Write for us
  1. Home
  2. Sample chapters

Grouping, sorting, and filtering pivot data

Bill Jelen
  • By Michael Alexander and Bill Jelen
  • 4/7/2019
Contents
×
  1. Using the PivotTable Fields list
  2. Sorting in a pivot table
  3. Filtering a pivot table: an overview
  4. Using filters for row and column fields
  5. Filtering using the Filters area
  6. Grouping and creating hierarchies in a pivot table
  7. Creating hierarchies
  8. Next steps
  • Back
  • Page 8 of 8

Next steps

In Chapter 5, “Performing calculations in pivot tables,” you’ll learn how to use pivot table formulas to add new virtual fields to a pivot table.

Save to your account
  • Back
  • Page 8 of 8

This chapter is from the book

Microsoft Excel 2019 Pivot Table Data Crunching

Microsoft Excel 2019 Pivot Table Data Crunching

  • Learn more Buy

Related resources

  • Titles
  • Chapters
Microsoft Excel Pivot Table Data Crunching Including Dynamic Arrays, Power Query, and Copilot

Microsoft Excel Pivot Table Data Crunching Including Dynamic Arrays, Power Query, and Copilot

  • By Bill Jelen
  • eBook $35.19
Collect, Combine, and Transform Data Using Power Query in Power BI and Excel

Collect, Combine, and Transform Data Using Power Query in Power BI and Excel, 2nd Edition

  • By Daniil Maslyuk, Gil Raviv
  • eBook $31.99
ChatGPT with Excel: Leverage ChatGPT for Data Success (Video)

ChatGPT with Excel: Leverage ChatGPT for Data Success (Video)

  • By
  • Online video $119.99

See related titles

  • About
  • |
  • Contact us
  • |
  • Cookies
  • |
  • Privacy notice
  • |
  • Do Not Sell My Personal Information
  • |
  • Terms of use
  • © 2025 Pearson Education. All rights reserved.