Skip to main content
Question

How to create a Pivot table in Quickbase

  • January 30, 2018
  • 0 replies
  • 237 views

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.
This topic has been closed for replies.

Currently a summary report can only summarize numeric values and not dates. So I don�t have a solution to offer.

  • Author
  • Registered
  • January 30, 2018
Okay. Thank you.

  • Author
  • Registered
  • January 30, 2018
Can we hide the header part for a report? 

Sorry, I don't know what you mean by hiding the header part.

  • Author
  • Registered
  • January 30, 2018
Not to display the Fields in the report header.


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.