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