Well I figured out how to get pretty much what I wanted. I created a report formula like this. I just listed all of the senerios, which in my case was 9. It works out pretty good.
If([Status]="Open" and [Record Type]="Contract","Contract Open",
------------------------------
Carol Mcconnell
------------------------------
Original Message:
Sent: 09-08-2023 15:32
From: Mark Shnier (Your Quickbase Coach)
Subject: Summary Crosstab report
Can you add another Group by Row for the Record Type? it won't be exactly how you want it but will give you what you want in terms of the extra breakdown.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
Original Message:
Sent: 09-08-2023 11:18
From: Carol Mcconnell
Subject: Summary Crosstab report
I'm trying to add a second crosstab but I can't seem to figure out how to do it.
This what I currently have:
Status | Closed | Open | Pending | Totals |
Provider - County - Liaison Region | PR Assigned To | Number of | Number of | Number of | Number of |
| Records | Records | Records | Records |
This is what I want:
Status | Closed | Open | Pending | Totals |
| | | | Record Type 1 | Record Type 2 | Record Type 1 | Record Type 2 | Record Type 1 | Record Type 2 | |
| | | | |
Provider - County - Liaison Region | PR Assigned To | Record Type | Number of records | Number of records | Number of records | Number of records | Number of records | Number of records | Number of |
|
------------------------------
Carol Mcconnell
------------------------------