Remove totals column from summary report

  • 0
  • 1
  • Question
  • Updated 3 months ago
  • Answered
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?
Photo of QBuser

QBuser

  • 370 Points 250 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
The summary report has to 'total' or 'average' something.... so I'm not sure I follow your request to remove that...
Photo of QBuser

QBuser

  • 370 Points 250 badge 2x thumb
I am talking about the built in Total's column that Quick Base creates that totals all the displayed "total columns".
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
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)
Photo of QBuser

QBuser

  • 370 Points 250 badge 2x thumb
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.
Photo of Ann Swelgin

Ann Swelgin

  • 382 Points 250 badge 2x thumb
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>
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

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