How to create a Pivot table in Quickbase

Question

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.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Project 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Project 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Project 3&nbsp;&nbsp; &nbsp; &nbsp; Project 4&nbsp; &nbsp; &nbsp; &nbsp;Project 5        Start Date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1/1/2018&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01/15/2018       End Date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 6/30/2018&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 12/31/2018&nbsp;   Appreciate your help on this. Thank you.

quickbasecoachd · Answer

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

sudheerqb · Answer

Okay. Thank you.

sudheerqb · Answer

Can we hide the header part for a report?&nbsp;

quickbasecoachd · Answer

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

sudheerqb · Answer

Not to display the Fields in the report header.

Forum Discussion

How to create a Pivot table in Quickbase

Related Content

QuickBase Scripts

AI Smart Builder for Creating Apps and Streamlining Pipelines

How can I create a report in Quickbase that aggregates multiple rows into a single line per record?

create pipeline to create new records based on current record

Quickbase App Issues