I am currently evaluating Flexmonster for use in our app – so far everything has gone really well, and I am in the process of figuring out how to use calculated measures to display custom aggregation such as weighted averages.
Our data is often pre-aggregated, for example when displaying averages or standard deviation. This mostly works great with the flexmonster pivot, and I have been able to use calculated measures successfully to create custom aggregations such as weighted averages.
However, one problem I am struggling to solve is that even if I set the the caption for a measure, this seems to be used together with the aggregation, so the label reads “Sum of X”. The grand total caption seems to work as I expected, but the regular caption always appears together with the aggregation. I have made a jsfiddle based on one of your examples to illustrate:
Is this by design? If so is there another way to override this label to show a custom caption without the aggregation? eg. Just ‘Price’ rather than ‘Sum of Price’?
Thank you for your question.
It seems that you are looking for showAggregationLabels property. Please refer to our docs for more information: https://www.flexmonster.com/api/options-object/.
Also here is the jsfiddle example: https://jsfiddle.net/flexmonster/x4caeonm/2/.
Please let us know if everything works fine for you.
Thanks Dmytro, that works great. I started trying to use customizeCell to replace the labels but this is exactly what I was looking for