Pivot Table: Remove Total

jumpmanjones

Board Regular
Joined
Apr 3, 2006
Messages
185
In my pivot table i just added another colum in the left side, and after it completes a section corresponding to a value of the previous column it puts a total column.

data 1 1
2
total 3
2 0
6
total 6
data2 1

2
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
Hi

Right click on the field, select Field Settings and Subtotals...None
 
Upvote 0
how do you edit "(blank)"

Click on the cell containing "(blank)", and enter " " in its place.

You can edit any item in a PivotTable. For example, you can change 1 to "Yes" and 0 to "No".
 
Upvote 0
The cell does not allow nothing in a cell, the message is as follows:
"Cannot enter a null value as an item or field name in a PivotTable report"
 
Upvote 0
The cell does not allow nothing in a cell, the message is as follows:
"Cannot enter a null value as an item or field name in a PivotTable report"

Enter a space character... char(32), " ".
 
Upvote 0

Forum statistics

Threads
1,213,494
Messages
6,113,988
Members
448,538
Latest member
alex78

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
Back
Top