Is there any way to make the results of a pivot behave more like a spreadsheet? See attachment. I want to see every row display every data element, unlike the pivot's merged grouping of a category.
Howdy. The only way to do that is to use VBA code. BTW, if you will be rebuilding the Pivot frequently, VBA is the absolute best way to go. Chapter 12 in the book VBA and Macros for MS Excel, by Bill Jelen, et all (MrExcel) is ideal, because he gives code on all phases of Pivots, including your request. When I have done this it is much cleaner, faster,a nd easier to change.
________ YAMAHA FZ1
