I am creating Pivot tables in Excel using a SimbaO2X data source connected to a Mondrian server.
In a normal Excel pivot you can click on a "value" field (Measure) and choose the type of aggregation that you want - sum, avg, count etc.
If instead you create a Pivot via the SimbaO2X/Mondrian the value fields have that option greyed out.
When you define Measure fields in the Mondrian schema you can only define one aggregator, for example
<Measure aggregator="min" formatString="Standard" column="positive" name="positive_min"/>
Is there any way to enable that setting in Excel?
I am thinking of something at the schema level, maybe a special way to define a group of Measures so that Excel understands that they are part of the same value field.