Forum Discussion

CarolMcconnell's avatar
CarolMcconnell
Qrew Captain
2 years 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
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    2 years ago

    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
      2 years ago

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