Forum Discussion

CarolMcconnell's avatar
CarolMcconnell
Qrew Captain
9 months ago

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
------------------------------

2 Replies

  • 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
    ------------------------------
    • CarolMcconnell's avatar
      CarolMcconnell
      Qrew Captain

      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
      ------------------------------