pivot table again

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have a range of fields in a pivot table some are qty others are value

how can i split the table into two seperate sections one showing qty and the
other showing values (if that makes sense)
 
If your quantities and values are in the same column, you'd need to use a
"helper column" that differetiates them (Qty vs Amt)

Then you can include that field in the pivot table before tha field
containing the quantities and amounts.

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
no the fields are in different columns

im looking more for a cosmetic fix because i can do to seperate pivot tables
but then i need to use two seperate filters

im looking to sreate a break after the first four columns in the table and
move the next four below but still all working off the one set of filter
values
 
You must log in or register to reply here.

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

Pivot table report invalid 0
pivot table help 2
Pivot Table Help! 1
Calculated field in pivot table 2
problem with date in the VBA macro 0
pivot table loosing decimals (vba) 1
Export Pivot table 1
making an excel table visible for external data on pivot table 1

Back
Top