Skip to main content
Question

How to change the appearance of a summary report?

  • Mar 11, 2022 3:46 PM UTC
  • 0 replies
  • 90 views
Forum|alt.badge.img+7
Hi everyone,

I'm not sure if it's possible, but it's what my boss wants for a particular report.

I currently have a report for # of people registered for events, organized by health regions, and then by community.  It looks like this (but with around 80 communities - so long and hard to read in this default format)​:

                                  Health Region 1  |  Health Region 2  |   Health Region 3
Community 1   -               5
Community 2 -                                                       10
Community 3 -                                                                                        7

and so forth.  But a community can only exist within a specific health region; so what she wants to see is a different way of rolling this data up.  Preferably a table more like this:

Health Region 1 - 50   |    Health Region 2 - 75   |   Health Region 3 - 90
   Community 1 - 5       |       Community 2 - 10    |        Community 3 - 7
   Community 7 - 15     |       Community 4 - 15    |        Community5 - 15
   Community 8 - 20    |       Community 6 - 25    |       Community 9 - 35
    etc.

Is this possible?  

Thank you for any guidance you can offer!
Take care,
Jen

------------------------------
Jennifer Juhasz
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+7
I've spent the whole day on this, and am no closer to a solution.

At this time, I've created 5 separate summary reports - one per health region - that lists their individual communities with the total # of registrations; and then have just put them side-by-side in a Dashboard. 

Even if I could find some way to add sub-totals to a summary report so I could break up the rows into groupings by the 'health region' parameter, it would be a step forward; but I don't think this is possible either.

I also am not sure if I create a totally separate table and use formula queries to populate it, that I could get the data that I need.  Is this just another function that Quickbase cannot do, but Excel can?

Thank you!​

------------------------------
Jennifer Juhasz
------------------------------
Terms & ConditionsAccessibility statement