Hi,
I have a pivot table that consists of a store number and vendor name in
the row. The total dollar amount is in the data. There are are more
vendor names than store numbers. When I run the pivot it gives me the
store number once and the fills in all the vendor names with the dollar
amount. Example:
Store Vendor2 Amount
2 a 1
b
2
c
3
d
4
I would like the Store # to be repeated. Any ideas?
Thanks,
Eddie
--
punter
------------------------------------------------------------------------
punter's Profile:
http://www.excelforum.com/member.php...fo&userid=2044
View this thread:
http://www.excelforum.com/showthread...hreadid=491967