Calculated Fields : Get % from Actual/Target How to do

**nanutum** · 11-14-2016, 03:16 AM

Capture.PNG

I have Actual and Target when i use Pivot table It show sum of % i want show Actual/Target all

YELLOW : 537.26% Must to be 102%

on data table is Actual/Target
i must change on Data table ?

Sorry about my English

**xlnitwit** · 11-14-2016, 03:26 AM

Hi,

It would help to see a sample workbook. I believe you need a calculated field in the pivot table rather than in the source data.

**nanutum** · 11-14-2016, 03:31 AM

sample workbook

Capture2.PNG

**xlnitwit** · 11-14-2016, 04:30 AM

That is a picture rather than a workbook. However it appears to confirm my thoughts- namely that you need to create a calculated field in the pivot table that is simply
='Actual'/'Target'

Calculated Fields : Get % from Actual/Target How to do

LinkBack

Thread Tools

Rate This Thread

Display

Calculated Fields : Get % from Actual/Target How to do

Re: Calculated Fields : Get % from Actual/Target How to do

Re: Calculated Fields : Get % from Actual/Target How to do

Re: Calculated Fields : Get % from Actual/Target How to do

Thread Information

Users Browsing this Thread

Similar Threads

Calculated Fields in a Pivot Table when 'Fields' appear over Muliple Lines

Actual Vs. Target chart

Stacked Bar for Target vs Actual + Projection?

Calculating Target/Actual Grades

Compare two values Target Vs Actual

[SOLVED] Calculated Fields Based on Running Total Fields?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions