Skip to main content
Question

Remove totals column from summary report

  • November 6, 2017
  • 0 replies
  • 518 views

I have a summary report that I use to summarize information by week.  I would like to only display the previous 4 weeks, but when I do this the "Totals" column just shows those 4 weeks for totals which is confusing based on what is displaying for other reports on the dashboard.

I know that you can remove the totals row.  Is there a way to remove the totals column in a summary report?
This topic has been closed for replies.

  • Quickbase Alumni
  • November 6, 2017
The summary report has to 'total' or 'average' something.... so I'm not sure I follow your request to remove that...

  • Author
  • Quickbase Alumni
  • November 6, 2017
I am talking about the built in Total's column that Quick Base creates that totals all the displayed "total columns".

  • Quickbase Alumni
  • November 6, 2017
Yes, by default a "summary report" is going to total something and group them together.

Is there some other value that you can 'summarize' as to show the value you are looking for?

Or maybe a different type of report to help have the impact you are looking for?
(hard to tell without a use case or more context)

  • Author
  • Quickbase Alumni
  • November 6, 2017
The summary report would still calculate the totals for each week.  I just do not want it to display the overall total column that totals all the weeks that Quick Base automatically creates.

It seems like there should be an option to remove the overall total column like you can remove the total row, but I guess not.

  • Quickbase Alumni
  • August 13, 2018
would love to see an option to remove the OVERALL total column. It's confusing for the user if they just want to see a 2 year comparison for example. They always ask me "why are there 3 years on my report"? <rolling eyes>

I agree, if you put in a User Voice I would give you some votes. 

There is an option to remove the "Totals" but by that they mean the totals at the bottom, but not the totals to the right side.  I have many summary reports where conceptually those right side totals are meaningless and hence confusing.

  • Quickbase Alumni
  • January 30, 2019
I was looking for the same thing and thought i would post the resolution just in case others have this same question...

You should be able to un-check the "Display a total of this field in reports" in the related field settings

TateForgey
Forum|alt.badge.img+7
  • Quickbase Alumni
  • June 10, 2020
Quick Base, please, please give us the ability to remove this.  I'd rather have the ability to remove the column than the row!

------------------------------
Tate Forgey
------------------------------