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!