Solved

Applying filter to KPI calculation

Forum|Forum|3 years ago
May 19, 2022
3 replies
28 views

alex.timm11
Level 3

Hello everyone,

here is my case: I am using SAP table CRMD_ORDERADM_H as case table. I am using PU_SUM to have an OLAP table column with the sum of CRMD_ORDERADM_I.NET_VALUE grouped by CRMD_ORDERADM_I.HEADER (case id). I am using a dropdown to filter for CRMD_ORDERADM_I.ORDERED_PROD. It works in so far that the table only shows cases, where at least one item has the selected PROD, but the sum stays the same.

I would like the filter to be applied to the sum.

In case you are not familiar with SAP tables - I added a mock up of what I am trying to do.

Have you got any ideas how I could accomplish that?

Thanks in advance!

Best answer by neil.whita

Hi Alex,

I think you want to use FILTER_TO_NULL here but I believe it's quite intensive and can affect query performance.

So instead of PU_SUM(CASES,CRMD_ORDERADM_I.NET_VALUE)

you apply FILTER_TO_NULL around the column

So instead of PU_SUM(CASES,FILTER_TO_NULL(CRMD_ORDERADM_I.NET_VALUE)).

When you then apply filters, the PU_SUM value will update according to the filters