How to control aggregation in grouped rows?

When I use the option: "table/Content/"..."/Advanced/Group rows by"
and choose a column to group by, I get grouped rows.
But in the top row of each group (the one with the group-by column value) I also get, by default, aggregation of all the numerical values in each column for that group.
In some cases this is not good. Adding up values of Year, or day number is not sensible. See snapshot below.
In posts here I've seen references to controlling these aggregations but having searched all over I just can't find them.
Can anyone tell me where I can find the aggregation options for grouped rows?

Screenshot 2025-03-08 152335

Hey @davblo,

You'll find that setting within each column's settings, there's an aggregation field as shown below:

image

1 Like

Ha ha, I can't believe I missed that!

Thanks for pointing it out!

2 Likes