Aggregator on the subtotal only

[tgmweb]

I'm looking to see if it's possible to have a different aggregator on the subtotal (but only the subtotal).

You can do this in Excel by choosing "summarize values by".

An example might be "Average of Child Row" - where the subtotal would display an average of the aggregated child rows - so for example I'd use a sum aggreator (and when expanded you'd see the sum values), then an average aggreator for the subtotal which would show an average the child rows..

is this possible somehow?

Thanks,

Tom.

[nagarajanchinnasamy]

@tgmweb this is not possible with current implementation. But this requirement will make this plugin more generic summarizer than just totaling up.

However, how do u plan to get input from user for summarize values by? This will require changes to PivotUI user interface.