Turn Off Total Row in Pivot Table (Workspace Configuration)

[jstoessel]

I'm working on building some pivot tables and need the ability to hide the Column Total.

The reason being that the breakdown of the items (rows) are generating values which are averages.  These averages are correct.

The pivot table is then combining the rows and doing a new average total value - this is not what I want to display.  The rows should not be combined for an overall average.

I have scoured and scoured looking for a way to disable column totals - but have not found one yet.  Here is a snapshot showing the issue.  My accounting brain understands what is happening - but users will be confused when the columns do not balance.

[Andrew_TND]

Hello try the below:

1. Navigate to the workspace where the pivot table is.
2. Click on the "Edit" button to enter edit mode for the workspace.
3. Locate the pivot table component within the workspace.
4. Click on the pivot table component to select it.
5. In the properties panel or settings for the pivot table component, look for an option related to totals or grand totals and deactivate.

Please mark as helpful or if it’s resolved the issue, CORRECT!

[jstoessel]

There is no such property to be found - Joh

[Andrew_TND]

Ah, apologies clearly I’ve been given duff information.