I am working on a dashboard to summarize Company Payroll information.
I’d like to display a comparison of payroll by department for the current year to date versus the previous for the same period.
Data for this report will come from table:PAYCHECKS with the fields shown below:
- fk_ID Dept
- Date_ Payroll
What is the best way to approach this? e.g. Separate portals containing summary data for Current Year to Date and Previous YTD based on different TO's or an Execute SQL query or ???