pivottable column

  1. X

    Simplest way to compare tabular data for two dates (preferably using PIVOT)

    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...
  2. D

    Using one PivotTable and switching between column fields

    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...
  3. K

    Keeping Blank Columns when applying a slicer to a table from PowerPivot

    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...
  4. P

    How to use pivot table to get a value by multiplying two different datas

    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...
  5. S

    PivotTable Column Addition

    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...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top