Pivottable total cloumns
 

I have created a pivotable and I would like to have more than one type
of data in the total column(Qty, AUP, Total). The problem is that
when I add more than one item to the total column in the pivottable,
it stacks the data rather than creating more columns side by side. Is
there a way around this?

Thanks

Pivottable total cloumns
 

What you need to do is drag the field label with the data
to your right and this will create the columns that you
need.

Just play with the field labels on the table and you will
see how it changes.

Andres

-----Original Message-----
I have created a pivotable and I would like to have more
than one type
of data in the total column(Qty, AUP, Total). The
problem is that
when I add more than one item to the total column in the
pivottable,
it stacks the data rather than creating more columns side
by side. Is
there a way around this?

Thanks
.