How to use Aggregation function in a table

[#1]

Hey,

I am curious about how to use the aggregation function within a table in a story to calculate the average value of a certain measure over time where time acts as dimension.

When I open the fx editor within the measures I don't get the "Aggregation" option in the dropdown. If I open the "Add measure" dropdown I am not able to create a new measure from calculation (other than in this tutorial)

So how to come about it? Note that the option is well available once I switch to a barchart e.g.

[horynao]

Hello, if you try to do it all under data import, is it all right? SAC like live connection from S4/HANA mostly. Other live conn have some issues.. For examle I didnt even calculate percentage under live data from SAP Universe.. aggregation was possible.

Also you could look to support matrix, if you connection is not old version SAC Wiki.

Good luck

Ondrej