Creating a pivot table with attributes that don't "stack"

**athomas003** · 07-06-2011, 05:20 PM

Hi there!

I'm going to use silly categories to try to describe this report I need to make. My table has three kinds of fruit (apples, oranges, pears), and I need a report that reflects (a) how many pieces of fruit are of which quality (low, medium, high), and (b) how many pieces of fruit belong to whom (Mary, Mark). I do not need to know how many of Mary's fruits are of medium quality or anything like that; the two attributes are independent, and I'd like to get them all on one chart. Is this possible? By default, Excel is nesting them in each other.

I've tried to Google it and search around this forum, but I'm not sure of the wording I should be using to describe these things, so I haven't found anything.

**NBVC** · 07-06-2011, 10:09 PM

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!