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
»
- Add new comment
- 798 reads
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.
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
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