Calculated Field

J

jonespandrew

New member
Joined
Jan 27, 2016
Messages
122
Reaction score
0
Points
0
Hi there this is my pivot table However I am trying to create a Percentage colum at then end wich works out the pass rate Grand total /pass how can i do this.

Region (All)
Lot(All)
Amey?(All)
Complete By(All)
Count of Test/Pass/IP/Overdue/FailColumn Labels
Row LabelsFAILEDIN PROGRESSOVERDUEPASSED(blank)Grand Total
FOSTON HAL621268295
GARTREE448409461
GLEN PARVA13147256317
LEICESTER169240310
LINCOLN547435487
MORTON HAL5855266334
N SEA CAMP11225236
NEWBOLD2992121
NOTTINGHAM174546621
ONLEY18532636691
RANBY188561650
STOCKEN74425499
SUDBURY635296337
WHATTON432483519
(blank)
Grand Total532566251385878
 
It would be easier to work on a real sheet than on what you gave us
 
Hi jonespandrew

See if this is what you wanted.
In future please supply a worksheet with the data and expected result.
It will be easier for us to help.
 

Attachments

  • jonespandrew.xlsx
    15.3 KB · Views: 18
You must log in or register to reply here.
Back
Top