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