Pivot Table for Dummies

G

Guest

I'm trying to create a pivot table for my sales staff from an excel
spreadsheet which contains the sales data.

The spreadsheet contains many rows containing names and 3 columns containing
sales data.

What I'm trying to do is create a pivot table showing the names of the sales
staff on the left and displaying their totals in 3 columns on the right.

The row of names displays properly, but I can't seem to have the column data
displayed correctly.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Value filter missing in pivot table 3
Display No Data in Pivot 1
Pivot tables 2 row labels 4
Grouping in a Pivot Table 1
Pivot Table Data Column Sort Excel 2007 1
changing year grouping in pivot table 4
Pivot table consolidation 1
Pivot Table - 3

Top