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?

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------------------------------

Hi Quickbase, it's been a few years since this post.... but I for one REALLY want to be able to remove the totals column on the far right. Extremely meaningless and somewhat confusing on some of my reports which use rich text summaries to create words.------------------------------Matt Stephens------------------------------

The summary report has to 'total' or 'average' something.... so I'm not sure I follow your request to remove that...

I am talking about the built in Total's column that Quick Base creates that totals all the displayed "total columns".

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)

Remove totals column from summary report

TateForgey
Qrew Assistant Captain
5 years ago
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
------------------------------
- MattStephens
  Qrew Cadet
  2 years ago
  Hi Quickbase, it's been a few years since this post.... but I for one REALLY want to be able to remove the totals column on the far right. Extremely meaningless and somewhat confusing on some of my reports which use rich text summaries to create words.
  
  ------------------------------
  Matt Stephens
  ------------------------------
  - JamesCalloway
    Qrew Trainee
    2 years ago
    Agreed. In some cases the totals column(s) in a summary report are simply incorrect, such as when reporting return on investment or certain other percentages. Those cannot simply be totaled. They have to be recalculated based on the aggregated data.
    
    ------------------------------
    James Calloway
    ------------------------------
MCFNeil
Qrew Captain
8 years ago
The summary report has to 'total' or 'average' something.... so I'm not sure I follow your request to remove that...
QBuserQBuser
Qrew Cadet
8 years ago
I am talking about the built in Total's column that Quick Base creates that totals all the displayed "total columns".
MCFNeil
Qrew Captain
8 years ago
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)
QBuserQBuser
Qrew Cadet
8 years ago
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.
AnnSwelgin
Qrew Trainee
7 years ago
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>
QuickBaseCoachD
Qrew Captain
7 years ago
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.
AaronSnow
Qrew Cadet
6 years ago
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
- NigelHo
  Qrew Trainee
  6 years ago
  I am looking for the same resolution, I have tried what Aaron has suggested but doesn't seem to work.
  
  Anyone else have any luck?
  
  ------------------------------
  Nigel Ho
  ------------------------------

Forum Discussion

Remove totals column from summary report