Hello everyone,
Im trying to create reports in my app and I’m trying to use a RG to achieve that but I have not been able to figure out how to group similar items together.
For clarification, in my app users can keep records of their expenses which have been grouped into categories already ( Insurance, Transport, accommodation) and enter the amount and the date the expenses was incurred. Following this logic for instance a user could incur Transport expenses for different days and different amounts.
Usually a repeating group will display all the list of the Transport expenses by dates and amounts.
However, I want to rather count all the respective Transport items entered and also get the grand total for all the transport expenses.
I am uploading a screenshot of what I am trying to achieve.
Thanks in advance for anyone that reponds.