Results 1 to 7 of 7

Thread: Calulated field

  1. #1

    Calulated field



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi From a Pivot table I have created I am trying to add in a field that show Percentage of calls attended and percentage of calls resolved, i know the formulae which is lowest number/highest number but how do i do this as a calculated field.

    I have toyed with the idea of having 3 colloums 1 to show attended 1 to show attended late then using a calulated field add those two colums together to show total calls attended then create a nother calulated feild showing total calls then work out the percentage from that.

    Hope it make sense

  2. #2
    Super Moderator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    454
    Articles
    0
    As we always point out, it's best to attach a sample workbook.
    Ali
    Enthusiastic self-taught user of MS Excel!

  3. #3
    Hope this make more sense

    Trying to create calculated field in pivot table called total attened which looks at from the pivot tables the Pass totals and fail totals and add thems together to give total attended

    Looks at the pass/Risk/Fail coloum and counts everything that shows Pass,Fail

    Tried this but did not work

    =Countif( 'Pass/Risk/Fail'="Pass"

    Also trying to add 3 coloums together using calculated field to add them up to a total in excel it would be =SUM(B33) How to I do this as a calculated field in pivot table the field names are
    Count of Attended on time Count of Attended Late Count of Not attended

  4. #4
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    723
    Articles
    0
    Quote Originally Posted by jonespandrew View Post

    How to I do this as a calculated field in pivot table the field names are
    If you can't post your pivot table as suggested by AliGW, then anything we can produce would at best be completely unrelated, and quite honestly a waste of time.
    I suggest that you look at some of the on line tutorials that include help with calculated columns in tables.

  5. #5
    Ok please see attached.

    Im trying to create a pivot table with the sites down one side and then the following colums next to it Total Attended, Total Resolved Total at risk, Total failed and Grand totals as calculated fields hope attached helps.

  6. #6
    Here is a quick and dirty, not sure it is exactly what you had in mind, let me know and will tweak/overhaul (not clear on total at risk?)

    Input new data as normal on Raw Data sheet (origional Table) and click refresh all to update PVT. Delete pivot table format that you do not require.

    Knock 'em dead sailor!
    Attached Files Attached Files

  7. #7
    Had a rush of blood to the head use this one, far less clunkie than test2 above
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •