In a table, when grouping by columns, I can select an aggregation type such as sum, which conveniently gives me a total for that group in the "grouped row". However, if I have a column with custom calculations, ex. column c / column d, the grouped row aggregation is calculated incorrectly, no matter what type of aggregation I select. If I don't select an aggregation, nothing shows up. How do I get the grouped row to show the correct calculated aggregated total when columns are grouped?
This would be so awesome. Another use case would be when having static category data - it show on the top parent row. In your example - if Campain had A in both rows - show it in the top row as well. Or for example, string values have the option of "Count Distinct" - if that Count Distinct is 1 - roll it up to the next level up.
Welcome to the community, @Mykola_Zavoritnii! This is a feature that we have continued to track, but haven't yet prioritized. Part of our hesitation is the potential performance ramifications of custom logic automatically executing for each grouped element, but I totally see the use case for more options, at the very least.
I'll bump this request internally and provide an update as soon as I can.
I'll follow up here if that changes