CODEWITHSUNDEEP
excelpivot
Selrac
Selrac

Reputation: 2293

Hide Excel Pivot items

I'm trying to find a way to hide some of the items in a pivot table that are not in the total summary. See an example below:

enter image description here

See also structure pivot fields with the highlighted fields I don't need to show the values except on the totals.

enter image description here

Any ideas on how to achieve this?

Upvotes: 0

Views: 35

Answers (1)

QHarr
QHarr

Reputation: 84465

Arrange fields like this:

Data

At present you have Product line for example included in rows which is splitting out your total. You need to remove these until you get the desired view. Report layout is tabular and subtotals are off.

Upvotes: 1

Related Questions