Can grand total sum max values?

Stefano · 2025-01-16T17:17:47+00:00

There was an error rendering this rich post.

anyone have any idea how (or if) it's possible to not show the MAX value in the grand total? I would like the grand total to be a SUM even if the values in that column are a MAX aggregation but the grand total should be the sum of the maxes if that makes sense :)

IMG_3300.jpg

Find more posts tagged with

Accepted answers

DashboardDude

@Stefano,

So one thing that I do is I like to make tiles which are independent of the table. That way you can make it whatever you want. Instead of ROAS across the row you can make each a KPI and do sums or whatever you want. I have found from my experience that if the number is super important - just give people the damn number right away. If someone wants a cheeseburger - just make them a cheeseburger. Don't make something overly complex.

All comments

DashboardDude

Hi @Stefano ,

Just to clarify, in that column you set the aggregation to be MAX, but you want the Total Row to show a Sum of the numbers instead of the Max right? If that's the issue, then I think the answer is no because the total is based on what you are aggregating. HOWEVER, you can set the summary number to be a sum instead of a max. Hope this helps.

Stefano

Thanks John!

Yes, you did understand my issue correctly. I was trying to get the total row to still sum instead of using the max aggregation function. I know that the summary number at the top can be set differently but I am using that already for summing the actual usage so I guess I need to keep the card as is and just make a note for folks not to get confused or have it be misinterpreted and this is where good old excel comes in I guess…. :(
Perhaps this would be worth an idea exchange.

DashboardDude

@Stefano,

DashboardDude

Here's that page if you want to see the whole template: https://www.dashboarddudes.com/templates