employee hour summary with redundant data

[ssutton]

I'm stuck!

I have a table of raw data that includes employee name, project, and hours worked by employee and client and project.  (Sample data attached).  The data for the Holiday Hours, Paid Time Off Hours and Total Time Off Hours are duplicated and therefore are summed incorrectly.  The data is stored in a database where the billable hours and non billable hours are separated, but count the time off and holiday for each row and it should not be.  I don't know how to either remove the redundant data or parse out the data to create a new table join.  No matter what I get errors because of many employees, many dates, and many clients (not finding the unique value)

.

[v-lili6-msft]

hi, @ssutton

How do you determine that which row of data is redundant? From your screenshot, I couldn't find the logic of how to determine which row of data is redundant. And It seems that you just want to replace the redundant Holiday Hours/ Paid Time Off Hours/ Total Time Off Hours with 0 and keep using other column data of the redundant data row. So I suggest you add three new columns: new Holiday Hours/ new Paid Time Off Hours/ new Total Time Off Hours 

logic like this:

new Holiday Hours = IF( conditional , 0 , Holiday Hours)

new Paid Time Off Hours = IF( conditional , 0 , Paid Time Off Hours)

new Total Time Off Hours = IF( conditional , 0 , Total Time Off Hours)

Then use these three new columns to create the visual.

Best Regards,

Lin