Discussions

Expand all | Collapse all

How to create a Pivot table in Quickbase

  • 1.  How to create a Pivot table in Quickbase

    Posted 01-30-2018 14:52
    Summary report is one where we can create a report like a pivot table with totals on some fields. But I want a Pivot table as below. I have a project table with start and end dates for each project. I would like to display a pivot table as below.


                                    Project 1            Project 2              Project 3       Project 4       Project 5

    Start Date               1/1/2018            01/15/2018
    End Date                6/30/2018          12/31/2018 


    Appreciate your help on this. Thank you.


  • 2.  RE: How to create a Pivot table in Quickbase

    Posted 01-30-2018 14:53
    Currently a summary report can only summarize numeric values and not dates. So I don�t have a solution to offer.


  • 3.  RE: How to create a Pivot table in Quickbase

    Posted 01-30-2018 17:03
    Okay. Thank you.


  • 4.  RE: How to create a Pivot table in Quickbase

    Posted 01-30-2018 17:04
    Can we hide the header part for a report? 


  • 5.  RE: How to create a Pivot table in Quickbase

    Posted 01-30-2018 17:23
    Sorry, I don't know what you mean by hiding the header part.


  • 6.  RE: How to create a Pivot table in Quickbase

    Posted 01-30-2018 17:46
    Not to display the Fields in the report header.



  • 7.  RE: How to create a Pivot table in Quickbase

    Posted 01-30-2018 17:49
    There is not a native method to suppress the table column headings.  If you click on the drop down triangle next to the field name, you will be able to override the words with say a "."  That would change the heading to be a period.