Search the Community
Showing results for tags 'subgroup'.
I have created a search and report page to display time sheets for employees. We have different "types" of time: regular, holiday, sick, vacation, personal, and bereavement. The employee selects this from a drop down when submitting time sheets. When running the report, I would like the data to be sorted by date, to keep it as easy to read as possible. However, at the bottom of the report, I would like a total of all the hours as well as totals for any types indicated (i.e. Sick Total 4 hours, Vacation Total 8 hours, Regular Total 28 hours, Total 40 hours). I can get totals for subgroups and overall, but that automatically sorts the data by the subgroup (Type), so the data is sorted by Type before Date. I'm including a screen shot for reference. Can you tell me how to get all the totals to appear at the bottom, so I can sort by Date? Thanks!