Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

pivot tables

ResolvedVersion 2003

Renate has attended:
Excel Advanced course

Pivot Tables

How do you know which parts of a table to put where in a Pivot Table?

RE: Pivot Tables

Hello Renate
Thank you for your question

This depends on what you want the pivot table to show and how many columns of data you are using in your pivot table. You
can drag any field in the field list to any area, so your choice should be based on what you want to display and how you want to display it. You put values that you want to sum or count in the middle section such as sales value for example. The rest you can experiment with to see the different ways it will be presented.

If this resolves your question, please mark it as resolved. If not, please reply with more information.

Kind regards
Cress

Excel tip:

Stop Formula Returning A "#DIV/0" Error

If a formula returns a #DIV/0 error message there is a way to avoid such results.

For example the formula =A1/B1 will return a #DIV/0 if B1 is empty or a zero.

If you protect your formulas with the ISERROR function, the formula will then look like this:

=IF(ISERROR(A1/B1),0,A1/B1)

In plain English: should the result of A1 divided by B1 be an error change the result to 0 else show the result of A1/B1.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.