How to Sort and Filter data in Pivot Tables?

image_pdf

Pivot Table are very useful while working with large database. Read more about How to insert Pivot Tables?

Sort and Filter in Pivot tables 

1. To sort data in Pivot Table, select any cell from the column you want to sort by.

2. Go to Options and select sort type(Largest to Smallest or Smallest to Largest) from Sort & Filter field.

Result:

Filter Data:

We can filter data by adding field to the Report field. For example, to filter with City, select City field from field list and drag it to the Report field

Report Field will appear in First row. Select city to get details.

1,672 total views, 1 views today

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>