I have a table with these two columns: “Name” and “Total Net Value”. The dimension is a simple column (NAME1) from the “KNA1” table. The KPI “Total Net Value” is calculated as follows:
PU_SUM(“KNA1”, PU_SUM(“VBAK”, “VBAP”.“NETWR_CONVERTED”) )
Now, i should get all customers with the total net value. This should be fine. Next step, I want to create a custom KPI which should give me a cumulative sum of total net values from all customers. So, every row should have the same cumulated number in the third column. I want to archieve this with the global function. But unfortunately, this function can not handle PU_X function as aggregation… How can I solve my problem here?
Thank you in advance!