Pivot Table: Remove Total

[jumpmanjones]

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

[Domski]

Hi

Right click on the field, select Field Settings and Subtotals...None

[jumpmanjones]

Thanks


how do i make the (blank) display nothing ""

[Domski]

Don't quite follow what you mean.

[Mark W.]

Thanks


how do i make the (blank) display nothing ""

Edit "(blank)" to make it " ".

[jumpmanjones]

how do you edit "(blank)"

[Mark W.]

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

[jumpmanjones]

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"

[Mark W.]

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), " ".

[jumpmanjones]

Thanks so much