How to create a Pivot table in Quickbase

  • 0
  • 1
  • Question
  • Updated 9 months ago
  • In Progress
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.
Photo of Sudheer QB

Sudheer QB

  • 140 Points 100 badge 2x thumb

Posted 9 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,006 Points 50k badge 2x thumb
Currently a summary report can only summarize numeric values and not dates. So I don’t have a solution to offer.
Photo of Sudheer QB

Sudheer QB

  • 140 Points 100 badge 2x thumb
Okay. Thank you.
Photo of Sudheer QB

Sudheer QB

  • 140 Points 100 badge 2x thumb
Can we hide the header part for a report? 
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,006 Points 50k badge 2x thumb
Sorry, I don't know what you mean by hiding the header part.
Photo of Sudheer QB

Sudheer QB

  • 140 Points 100 badge 2x thumb
Not to display the Fields in the report header.

Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,006 Points 50k badge 2x thumb
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.