Discussions

Expand all | Collapse all

Nested Pivot Table Header AKA Two Row Header Summary Report Needed

  • 1.  Nested Pivot Table Header AKA Two Row Header Summary Report Needed

    Posted 03-14-2017 20:32
    Anyone have suggestions on the how to create the following...

    I'm needing to create a two-level summary report (aka Pivot table with two-header row).

    For the report on the vertical, I'd like a Manager field.

    ...

    For the horizontal, I'm needing to group (at the top) Week Number and then beneath it (Group Values) 

    so that I can see  something like this...

    +---------+-------------------+-------------------+-------------------+
    |         | Week 1            | Week 2            | Week 3            |
    +---------+-------------------+-------------------+-------------------+
    | Manager | Group 1 | Group 2 | Group 1 | Group 2 | Group 1 | Group 2 |
    +---------+---------+---------+---------+---------+---------+---------+
    | Mgr1    | 12      | 3       | 0       | 4       | 6       | 8       |
    +---------+---------+---------+---------+---------+---------+---------+
    | Mgr2    | 3       | 0       | 0       | 10      | 8       | 11      |
    +---------+---------+---------+---------+---------+---------+---------+


  • 2.  RE: Nested Pivot Table Header AKA Two Row Header Summary Report Needed

    Posted 03-14-2017 20:58
    Something like this?



  • 3.  RE: Nested Pivot Table Header AKA Two Row Header Summary Report Needed

    Posted 03-14-2017 21:02
    Close...

    Each "cell" Group is an independent value of each other.   Also, we want each cell to be drillable so that we can get (click) the qty behind it and show those items in a table.


  • 4.  RE: Nested Pivot Table Header AKA Two Row Header Summary Report Needed

    Posted 03-15-2017 02:56
    I believe its just a matter of how the data is coming in or which table you are building the report.

    Can you describe the info you are trying to display?  Is it all in one table?  if not, what are the other tables and relationships involved.

    It may just require some tinkering to get it where you need.  Different grouping options, report variations, etc.


  • 5.  RE: Nested Pivot Table Header AKA Two Row Header Summary Report Needed

    Posted 03-15-2017 06:34
    Hi Mathew,

    Can you please take a look at my question?

    https://community.quickbase.com/quickbase/topics/create-a-sub-total-row-in-summary-report

    Thanks,
    Gaurav


  • 6.  RE: Nested Pivot Table Header AKA Two Row Header Summary Report Needed

    Posted 03-15-2017 02:57
    If you are working with a Service person at QB who help build the app they can help.  Or the development company you worked with.  It may just need somebody with some outside eye to sort it out for you.