Skip to Content

Calculating average by month on SAP ANalytics Cloud

Hello everyone, i'm having a problem showing average values by month on a table.

I did it the steps from the history:

1.- Aggregation Functions.

2.- I selected my measure.

3.- I wanted show the average by month, so i selected the date dimension.

4.- Result only by year, not by month. By example, the average between January and February is 24050,04. Between February and March is 23407,39.

What must i do? I must create other formula or the BOC gives the option to reach the result.

Thank you very much for the help that can provide me.


screen1.png (43.3 kB)
screen2.png (84.8 kB)
screen3.png (46.3 kB)
Add comment
10|10000 characters needed characters exceeded

0 Answers