Very neat, Herbert!
I like the trick of Sales^0 - definitely one to remember.

--
Regards
Roger Govier

"Herbert Seidenberg" wrote in message
...
Excel 2007 Pivot Table
Same procedure as smartin's,
plus a few tricks.
http://www.mediafire.com/file/o0mwvn...06_10_09c.xlsx