+ Reply to Thread
Results 1 to 4 of 4

Need pivot table which calculates daily outage %

  1. #1
    Registered User
    Join Date
    02-09-2015
    Location
    Bangalore
    MS-Off Ver
    2013
    Posts
    32

    Need pivot table which calculates daily outage %

    Hi,

    This is what I need:

    1) In the sheet 1, should have dates & names of employees (Like in the attached sheet)
    2) If a person is present, the cell is "1", if the person is absent, the cell is "0".
    3) Need to calculate the daily outage% (using Pivot only)

    i.e. I need to calculate the (number of people attended)/(total number of people)
    This needs to be a "CALCULATED FIELD" in the pivot.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    02-15-2015
    Location
    Joburg, South Africa
    MS-Off Ver
    2007
    Posts
    8

    Re: Need pivot table which calculates daily outage %

    Hi siddharth_s1,

    Check the attachment. I hope this helps. Additionally, I have just a conditional formatting to every single date which has an outage.
    Hope this helps.

    Thanks

    Vishnu
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    02-09-2015
    Location
    Bangalore
    MS-Off Ver
    2013
    Posts
    32

    Re: Need pivot table which calculates daily outage %

    Thanks Vishnu.
    But is it possible for the outage to be added as a calculated field in Pivot table
    Pivot Table tools --> Analyze --> Fields, Items & Sets --> Calculated Field.

    Thanks.

  4. #4
    Registered User
    Join Date
    02-15-2015
    Location
    Joburg, South Africa
    MS-Off Ver
    2007
    Posts
    8

    Re: Need pivot table which calculates daily outage %

    Hi siddharth_s1,

    I have created the formula in the calculated field in pivot.

    Formula is:
    =IF(Total=4,0,Total/4)
    Look at the attachment as well please.

    Thanks
    Vishnu
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Need a pivot which calculates outage
    By siddharth_s1 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-17-2015, 11:23 AM
  2. Replies: 3
    Last Post: 10-01-2013, 05:05 AM
  3. Need help with a daily pivot table report URGENT!!
    By kturner1 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-19-2013, 10:05 AM
  4. Daily score/weekly average pivot table
    By XANADU79 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-24-2011, 05:08 PM
  5. Daily Difference in Pivot Table
    By agentred in forum Excel General
    Replies: 2
    Last Post: 01-06-2010, 03:24 PM

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