In previous versions of Excel I could get a report like this
Product Colour Count
Where the data fields Product and Colour were both listed down the page and were NOT nested.
In Excel 2007 it nests the second row label under the value of the first and this is not what I need.
Can someone please tell me how to turn off the automatic nesting.
Product Colour Count
Where the data fields Product and Colour were both listed down the page and were NOT nested.
In Excel 2007 it nests the second row label under the value of the first and this is not what I need.
Can someone please tell me how to turn off the automatic nesting.
