It would be important to have an option to add more than one option in Group Aggregate, just as there are multiple options in GroupBy, and to be able to change the order of the aggregates.
Since I’m Brazilian, it would also be important to have these words translated in the Localization settings, for example: SUM, COUNT, MIN, MAX, AVERAGE.
If anyone has already solved this problem, feel free to show us how to do it.
While AppSheet doesn’t currently offer a native pivot table feature, you can achieve a very similar result using a creative workaround. This video provides an excellent walkthrough of the process—I highly recommend taking a look!
Note that I have also created a new-feature request for this.
One simple workaround is to add one virtual column that merges what ever column value with e.g. total sum. When the result is the same for some rows, you can group with that VC. No need for anything “special”.
I watched the video and it’s a possible solution for simple summaries, however it doesn’t have the same dynamics and visuals as Group Aggregate, and it uses virtual columns, which I avoid using.
