View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier Roger Govier is offline
external usenet poster
 
Posts: 2,886
Default Non-nested rows/columns in a pivot table?

Hi Henrik

Do you mean that you have both Colour and Year as row items?
If so, drag one of them to be a Column item instead, or drag one of them
to be a Page item.

--
Regards

Roger Govier


"Henrik" wrote in message
...
Is it somehow possible to not have rows/columns nested?

Say, for example, that one field is 'colour' and another is 'year'. Is
it
possible to have one column with 'colour' and another with 'year'
rather than
a nested 'years per colour' or 'coulour per year' format?

I realize that it will give some problems with the sum rationale but
it
would sometimes be useful nonetheless.

Thanks
Henrik