In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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