Count List Items using Pivot Table summary Calculation

image_pdf

Pivot Tables are very useful in analyzing and calculating different fields in large database.

We can easily count number of products sold or fetch the maximum value from large database. Average of the multiple values can be calculated using Pivot Table.

Related Article: Easily manage database using Pivot Tables

Example:

We have the database of one of the section(Vegetable-fruits)- of big mall, which includes the different fruits and vegetable sold in different cities on each day. Pivot Table is comprising of 200 rows of data with No, Product, Category, City, Amount and Date field.

Download Example:Pivot-Tables

Here we have the summary of each product and Total amount Values.

Now we want to calculate number of days when particular products have been sold.

1. To do this, select any cell from Total field and right click to select Value Field Settings.

2. In Value Field Settings dialog box, Select sand click OK

3. It will count the number of days when each product had been sold.

3. Same way, select Average to get the average value of each product.

4. Select Max to get the highest sold amount of each product.

If you find this useful, you can stay connected with us on facebook to get more amazing tips and tricks of Microsoft excel.

2,553 total views, 1 views today

2 thoughts on “Count List Items using Pivot Table summary Calculation

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>