• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. J

    Cummulative %

    I have some data that I am using in a pivot table to calculate a utilization % each week. The chargeable hours and total hours are in the data by each person, each week. To calculate the utilization I created a calculated field of chargeable hours/total hours. This works fine when calculating...
  2. J

    Pivot Table Sum by Employee Name

    Yes, that is what I want. I have been using pivot tables so much, I did not think of tables. Is it possible to create a table that reads from the data sheet in my Excel file? Maybe I need to do a little research on tables. Can you point me in the right direction? Thanks
  3. J

    Pivot Table Sum by Employee Name

    Does anyone know if this is possible or of any tricks to get what I need? I have a list of org codes and people that hold certain responsibilities on the org code. I want to create a pivot table that displays the org code in a row, the reponsibility code as a column and then the person's name...
  4. J

    Pulling data into new worksheet from pivot table

    Hi - I have a pivot table that contains income statement information. Since pivot tables will not allow for insert of a row with a a formula I want to pull data from the pivot table into a new worksheet to obtain the format I need. Below is format of my pivot table. I have tried to use the...
Back
Top