Hello again, is there some reason that the measure aggregators are not available when in flat mode? The layout panel goes to a different modal, which is understandable, as the pivoting is not available, but totaling still is, and these will follow the behavior designated by the aggregator. I might be missing something.
Thank you for your question.
Currently, the other aggregations are not supported for the flat table.
Your request sounds reasonable and we will add it to our customer’s wishlist.
We will notify you as soon as it is added to our roadmap.
As a workaround, you can start with a calculated measure approach.
Please find the example here: https://jsfiddle.net/flexmonster/anexymzu/8/.
Let us know in case of any other question.
Dmytro, you can set the aggregators over in compact or classic mode, or set them programmatically, and then switch to flat mode and see the desired results, which is acceptable. It just seems odd that the toggles to switch are absent from the flat mode fields panel, but the aggregated totals are present in flat mode.
Thank for reporting it.
Yes, you totally right. The current behavior is not consistent with the compact/classic view.
We are going to add the necessary update which should allow switching aggregations from the Field List and also from the context menu.
Please expect the update at the end of the March.
We will notify you when it is ready.