I have a pivot table.
When I select any of the aggregations:
LIST_UNIQUE_VALUES
SUM
etc
I want it to automatically select my value “KWH” instead of having to select it. As I only have 1x possible value for it to choose from. Ideally I would like to remove the [sub] select box too…
I can’t find any way to set e.g. something like:
<chart:aggregations default="LIST_UNIQUE_VALUES">
<chart:aggregation mode="LIST_UNIQUE_VALUES"
**defaultSubValue = "KWH"/>**
<chart:aggregation mode="SUM" />
</chart:aggregations>