pivottable column

Hi. I'm looking for the simplest way to analyze data stored in a tabular format in an excel sheet and make comparisons (text as well as value fields) using dates as columns. To clarify, I have data for five days spanning over 20 different columns stored in an excel sheet. For each day, the date...

I have a PivotTable with names as the row and for the columns I want the user to be able to easily switch between chat total, email total, and call total, and then the values be whatever the chat, email, or call total is for the employees. Is there a way to do this without using the PivotTable...

Hi, I have searched everywhere and cannot seem to find an answer to this issue. I have a couple of pivot tables built from a powerpivot query of a database on one of our servers. These tables are showing similar information so i have applied a couple of slicers, such as owner and business...

Hi everyone. I am now working on how to use pivot table calculate revenue (by multiplying volume and price) of the company. For now, I have combine two data sheets which are volume sheet and price sheet and hence create a pivot table. But at the column field there it can only show volume or...

I am running XL 2004 on Mac OSX 10.6. I created a 3 column list I created a pivottable based on that list. NOW I add an extra column to LIST and need to be able to modify the Pivottable to include the missing column. There doesn't seem to be a way, (short of VBA programming) to modify the...