Pivot table

[vikesh]

I have a big database (am using excel 2000) which is sorted on Invoic
no. wise & then Itemno. wise. I have 2 queries:

1. I want a summary which shows Invoice no. (Key column), Item no.
other details of the database. But the summary pivot (using format no
5 of Format Report command) shows the Invoice no. once and then th
item details. what i want is that the invoice no. should repeat itsel
everytime with the item detail. is there some method for doing th
same.

2. In the same table we also have some text columns and some dat
columns. Can these columns be shown as it is in the pivot tabl
summary

 

[Debra Dalgleish]

1. The row headings show once in a Pivot Table, and you can't force them
to repeat.

To print the table with a heading on each row, you can create a copy of
the table, and fill the blanks:
http://www.contextures.com/xlDataEntry02.html

2. I'm not sure what you're trying to do. Text can only appear in the
row and column headings of the pivot table, not in the data area. To
have data appear "as it is", summarize by Min or Max, instead of Sum.