S
Stevielew
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
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