I don't know how else to word that title. Logically what I'm trying to do is simple. I just have no idea how to accomplish it in CR.
There is one table of information. I want to setup 3 different pieces of logic and 1) display the results grouped by each piece of logic and 2) give a count of the number of records in each group.
Here is the logic:
Results set 1: Display all results if Field A contains a certain text string. Give a count of those results.
Results set 2: Display all results if Field B contains a certain text string. Give a count of those results.
Results set 3: Display all results if Field B contains a different text string than Set 2. Give a count of those results.
It seems so simple. I just don't know how to do this in CR or really what to Google to specifically find info on this.
Any thoughts would be appreciated. I was thinking to use Formula fields for the logic, and I'm just stuck on how to end up using them properly, if that's even the route to take.
Ultimately I would also like to display the counts for each of these result sets in a table as well.