Pivot Table for Dummies
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. |
Pivot Table for Dummies
If I understand you correctly this explains the solution:
http://contextures.com/xlPivot02.html Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "kjmcewan" wrote: 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. |
All times are GMT +1. The time now is 10:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com