Creating a total for non-unique values

Just add all three columns in your Olap table i.e. as follows

VKONT 

SUM(BETRH)

FAEDN 

Olap table does a group by automatically, hence giving you the result. Hope this helps.

Hi Abishek, unfortunately not. I'll try to explain my problem in a better way! There is one specific VKONT in this table, but related to this Account, there are several payments (BETRH) listed. For a better overview, i had summed up the payments (BETRH), so there is only one line for each Account with the summed up amount of all payments. And now to the Problem. Each payment (BETRH) has an specific net due date (FAEDN). In the moment when I add this column to the table, the sum funktion doesn't work any longer. It's because the formula can't summarize the diffenrent dates in one field. My goal is, to only show the latest net due date in this. Is that even possible? Thanks! Dominik

Try the following

VKONT 

SUM(BETRH)

MAX(FAEDN)

Hi Dominik,

try it with Pull Up aggregations (PU_*): https://docs.celonis.com/en/pull-up-aggregation.html

e.g

PU_SUM(<case_table>, table_name.BETRH)

PU_LAST(<case_table>,table_name.FAEDN)