@AdamJaworski wrote: Global Connect GM
Please help with the aggregation function. I need to add up the months for the year cumulatively.
Below is the effect I want to get.
| Month |
Year |
Cost |
Accumulate |
| 01 |
2021 |
873 646,24 zł |
873 646,24 zł |
| 01 |
2022 |
975 894,97 zł |
975 894,97 zł |
| 02 |
2021 |
872 613,47 zł |
1 746 259,71 zł |
| 02 |
2022 |
1 127 169,20 zł |
2 103 064,17 zł |
| 03 |
2021 |
998 599,21 zł |
2 744 858,92 zł |
| 03 |
2022 |
1 443 874,39 zł |
3 546 938,56 zł |
| 04 |
2021 |
945 342,53 zł |
3 690 201,45 zł |
| 04 |
2022 |
982 992,69 zł |
4 529 931,25 zł |
Aggr() returns an array of values for the expression calculated over the stated dimension or dimensions. For example, the maximum value of sales, per customer, per region. The Aggr function is used for nested aggregations, in which its first parameter (the inner aggregation) is calculated once per dimensional value.
