I have a request to create a report that is grouped in such a way that one record can be in more than one group.
The criteria is like this:
Group1: If Submit Date > (Today - 5)
Group2: If Status = "In Progress" and Type <> "Ongoing"
Group3: If Status <> "Closed" and Type = "Ongoing"
Group4: If Status = "Closed"
Each group would display the same detail record info: ticket#, Status, submit date, priority.....
Technically a record submitted in the last 5 days could be in Group 1 and one of the other 3 groups.
Also a ticket submitted move than 5 days ago could be in more than one group.
Is there a way to do this so that a record can display it's detailed info in more than one group?