+ Reply to Thread
Results 1 to 2 of 2

Calculated field in Pivot table

  1. #1
    Registered User
    Join Date
    04-21-2012
    Location
    singapore
    MS-Off Ver
    Excel 2003
    Posts
    23

    Calculated field in Pivot table

    Hi,

    I am trying to create a calculated field that will do the following
    "Sum of bed_in_service / Sum of bed_occupied".. The new calculated field should appear on the extreme right of the pivot table.

    pls see attached for a pictorial view.



    Thanks
    Attached Images Attached Images

  2. #2
    Forum Contributor bonny24tycoon's Avatar
    Join Date
    04-02-2012
    Location
    Hell
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    405

    Re: Calculated field in Pivot table

    Hi There,

    If you could attach your file, I could do this for you




    Thanks,

    Bonny Tycoon


    **If I was able to help please click the small star icon at the bottom left of my post **

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1