breaking apart columns in pivot table
When you drop your items, you can either drop them above or below. If I'm
reading right, you'd want to grap pivot field and drop, then drop the items
below the categories displayed.
Pivotfield1
list
drag and drop here
That what you were looking to do?
"vbasean" wrote:
I have a pivot that needs multiple columns instead of overlapping columns
here's an example
PivotField1
Item1, Item2, Item3
PivotField2
Item1, Item2, Item3
PivotField3...
when I place these columns along side each other this is what I get:
PivotField1, PivotField2, ...
Item1 Item2
Item1, Item, Item2 Item1, Item2, Item3
It keeps tiering off of each column and I don't want that.
I want Each column with it's own subcolumns SEPARATE.
Any suggestions?
Thanks
|