Pivot Tables & Multiple Row Entries

P

POD

Hi,

When there are 1 or more descriptive fields in a pivot table and
the entries in field 2 or further on are repeated, the values in the
previous field are left blank for each repition of the subsequent
field.
This causes problems for further sorting etc...unless you use
formulas.

Does anybody know how to ensure that all cells in the descriptive
fields
(rows in the layout section) are populated with the appropriate value?

Thanks

POD
 
B

Bernie Deitrick

POD,

You can't do that, and have a pivot table. But you can copy the PT, convert it to values, and then
fill in the blanks by selecting Edit Go To.. Special Blanks (done immediately after the paste, with
the whole table of values selected), then pressing the up arrow once, and pressing Ctrl-Enter. Then
copy the whole table and paste values again.

HTH,
Bernie
MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple measures in MS Access pivot table-Sigma Value in Row not Column 0
sorting pivot table by sorts by "show value as" 1
Pivot table calculated field: multiply Sum of FieldA with Max ofFieldB 4
Re: Differences instead of sums in pivot table 2
calculate net income i.e. revenues (-) expenses in a pivot table 1
Totals For An Inside Row Field In a Pivot Table 1
Pivot table group dates 3
reference is not valid message for pivot tables based on Access query 4

Top