Calculate the sum of a certain column (OLAP table)

Hey there,

I am creating an OLAP table as an success reporting tool with the Purchasing Group as Dimension.

This formula …

(AVG (PU_COUNT(“EKPO”, “_CEL_P2P_ACTIVITIES”.“ACTIVITY_EN”, “_CEL_P2P_ACTIVITIES”.“ACTIVITY_EN” = ‘Change Price’
AND “_CEL_P2P_ACTIVITIES”.“EVENTTIME” > TO_TIMESTAMP(‘2017’, ‘YYYY’) AND “_CEL_P2P_ACTIVITIES”.“EVENTTIME” < TO_TIMESTAMP(‘2019’, ‘YYYY’)))

AVG (PU_COUNT(“EKPO”, “_CEL_P2P_ACTIVITIES”.“ACTIVITY_EN”, “_CEL_P2P_ACTIVITIES”.“ACTIVITY_EN” = ‘Change Price’
AND “_CEL_P2P_ACTIVITIES”.“EVENTTIME” > TO_TIMESTAMP(‘2019’, ‘YYYY’) AND “_CEL_P2P_ACTIVITIES”.“EVENTTIME” < TO_TIMESTAMP(‘2021’, ‘YYYY’))))

SUM (CASE WHEN YEAR(“EKKO”.“AEDAT”) = 2020
THEN PU_COUNT(“EKKO”,“EKPO”.“EBELP”)
ELSE NULL END)

(Company Saving Value)

… calculates the savings for every Purchasing Group in 2020 in comparison to 2018.

This is working fine.

If I calculate the formula as a single KPI as an overall saving, it will not show the accumulated saving per Purchasing Group (with their certain Change Price Ratio) but an overall saving without reference to the respective improvement by each Purchasing Group.

Is there any possibility to sum a column of my own OLAP?

THANKS in advance
Denis