Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Summary

Cyeo
5 - Atom

Hi everyone,

 

     I would have a report that show Departments, Location code, employee names, Regular hours worked and Overtime hours worked.  Hourly employees typically appear more than once because there are two pay periods per month.  I am trying to get 2 reports:

 

1) sorted by Department, followed by Location code, a one line summary of each person's Regular hours (one col) and OT hours (another column) and that a sub total per department.

 

2) second report is sorted by Departments, followed by Location code with a subtotal of Regular Hours (one column) and OT hours (another column) 

 

    Totally appreciate any help given. Sorry if I use the wrong label for this question.

 

Regards,

Caroline Yeo

1 REPLY 1
grazitti_sapna
17 - Castor

Hi @Cyeo, will it be possible for you to provide a sample dataset and expected result so that we can prepare a mock workflow.

 

Thanks.

Sapna Gupta
Labels
Top Solution Authors