Pivot Table

How do I get the pivot table to now hide text in their summaries?

For example usually a pivot table looks like this (without subtotals)..

Customer State Product

A IL XXY
(blank) MI XXY
B AR XXY
C MA XXY
(blank) HI XXY
(blank) IN XXY

Instead I would like it to look like this (almost like a new summarize data that I can rework with..

Customer State Product

A IL XXY
A MI XXY
B AR XXY
C MA XXY
C HI XXY
C IN XXY

I'd add a column to your data

I'd add a column to your data source that trim() 's the field.
This way the (blank) would be left out

Can't summary the Q'ty of the same prodcut code in Pivot Table?

I use PV table to summry the same product code but I get the product code duplicated and 2 line Q'ty.  How to get each only 1 line for 1 product code with 1 Q'ty only? 

For example:

#1   Q'ty 5

#1   Q'ty 10

 

How can we just get #1 Q'ty 15pcs?

Ebrose

Nick's picture

pivot tables

sounds like you have QTY as a row field.

Try changing it to a data field.

 

Here's a basic pivot table lesson is u need a refresher.

Teach Yourself Excel Lesson 25 - Create A Pivot Table

Nick's picture

pivot table display

not possible via a pivot table.. (that I have found anyway)

you might (dependent on what is actually being displayed) be able to replicate your desired display by sorting and using autofilter on the original data.