Force PivotTable To Count Multiple Records As One

  • Hello Everyone,


    I have a data dump I would like to put into a pivot table to know the number of days someone worked in a week. However due to the data dump when i put this into the pivot table the numbers are misleading when somone has worked on multiple activities on the same day. This counts as three or two days when really it was only one day. Is there any way to easily clean the data or fix this problem.


    I have copied a sample of the data and pivot table. The real data is extremely long thus I can't clean this manually.


    Thanks in advance.


    Jason

  • Re: Pivit Tables And Multiple Lines From Data Dump


    I have some difficulties to read or extract the file.
    Can you attache it again and perhaps use a ZIP format.

    Triumph without peril brings no glory: Just try

  • Re: Pivit Tables And Multiple Lines From Data Dump


    Perhaps a possibility could be to make the sum of hours worked during the day.
    In addition to make the split per activity during the day.
    See attached.
    If it does not work can show what could be the final result for you

    Files

    • OZ141771.xls

      (39.94 kB, downloaded 44 times, last: )

    Triumph without peril brings no glory: Just try

  • Re: Pivot Tables & Multiple Lines From Data Dump


    thank you for your quick repsonse. is there any way to not sure htis in hours but as a count?


    Thanks again.


    jason