sccardais

Summarizing Data in Dashboard Layout

Discussion created by sccardais on Sep 10, 2015
Latest reply on Sep 10, 2015 by erolst

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.

 

YTD Payroll Comparison.png

Data for this report will come from table:PAYCHECKS with the fields shown below:

 

  • fk_ID Dept
  • Name_Dept
  • Date_ Payroll
  • Amount_Pay

 

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 ???

Outcomes