Dear @shravya.b11 

As documented at Pull Up Aggregation (celonis.com), the Pull-Up-functions ignore the global filter state and are calculated only once.

If you just get the sum of "CASE WHEN ..." customer, you just use Customer as dimension and SUM aggregation as KPI in OLAP table instead of PU_SUM. Then you can filter PR_CASE by date picker as expected.

Best regards,

Kazuhiko

Hi @kazuhiko.takat12 

Thank you so much for your valuable inputs. We tried with simple SUM and it is giving correct results. But, our requirement was to create a KPI based on the above formula. So, we were specifically using pull up functions based on customer data.

We just found a solution from other sources : FILTER_TO_NULL which can be used specifically to avoid the standard behavior of aggregation functions. So, this worked for us.

Thank you :)

Dear @shravya.b11 

It is nice to hear that you can find your solution. FILTER_TO_NULL is new for me, so I am also helpful.