Pivot Tables & Percentages
 

Can anyone help me please?

My apologies if this has been dealt with on the list
before, but I've been unable to find anything.

I am trying to show a column of figures within a pivot
table as a percentage of another column.

If absolutely necessary I'd even be willing to add a
further column to the same sheet in order to reflect the
results. But ideally it should be within the pivot Table
itself.

I have 2 columns as follows:

YTD Actual
and
YTD Target

I want to show YTD Actual as a percentage of YTD Target.
Is this possible without exporting the detail to a
separate sheet?

Many thanks

Steve

One possible way

http://tinyurl.com/6bytz


Regards,

Peo Sjoblom

"Stevielew" wrote:

Can anyone help me please?

My apologies if this has been dealt with on the list
before, but I've been unable to find anything.

I am trying to show a column of figures within a pivot
table as a percentage of another column.

If absolutely necessary I'd even be willing to add a
further column to the same sheet in order to reflect the
results. But ideally it should be within the pivot Table
itself.

I have 2 columns as follows:

YTD Actual
and
YTD Target

I want to show YTD Actual as a percentage of YTD Target.
Is this possible without exporting the detail to a
separate sheet?

Many thanks

Steve