The Summer Cup has officially kicked off! Get ready to learn, connect, and compete! Complete Community engagement tasks to earn points and unlock exclusive Summer Cup badges for your profile. Learn more 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