Skip to Content
1
Jun 25, 2018 at 08:22 AM

Calculating average by month on SAP ANalytics Cloud

652 Views Last edit Jun 28, 2018 at 05:25 PM 2 rev

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.

Regards.

Attachments

screen1.png (43.3 kB)
screen2.png (84.8 kB)
screen3.png (46.3 kB)