How to group a report by formula field.
I need to create a report based on the following report:
This new report should be grouped by days and status. Then, each group should display the details of each record such as Report No, Open Date , Due Date and Summary.
It is not a problem to display the report details, but I need to know how to group them since it involve calculation.
Thank you in advance,
Once you insert a group based on the formula field, you can change the sort order to Ascending, descending or define a specific order as per your requirement.
Open Group expert ->Select the group and click on options.
There you can apply required settings.
Hope this helps!!!