View Single Post
  #1   Report Post  
Stevielew
 
Posts: n/a
Default 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