Report With Group By Claus ( as in SQL)
I have a table that has the following fields:
Lets say it has the following data:-
I want to create a report :-
I created a report using Sub-summary by EmployeeName(Leading) but it does not group by employee:-
Here's how it looks like:-
How do make it group by employee name and how do I do the subtotals an the grand total?
Your help will be very much appreciated.
P.s - if you see "Ant" with the background green color that is not what I want - dont know why the rows have that green color .