pivot table again

M

max power

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)
 
R

Ron Coderre

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
 
M

max power

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
 
Top