Calculation of a sum of values taking into account several criteria.

[Anonymous]

Hello,

I want to calculate the total of the sum of the various accounts numbers  in the credit, provided that in the same seat is the one o varios accounts in the debit.

I have a table like this:

Thank you very much and best regards.

[v-huizhn-msft]

Hi @Anonymous,

After research, I am still confusing about your requirement? For your example, 520000 and 170000 are in different seat, 520000+170000=690000, how to calculate the total, what's the rule? Could you please list the expected result based on the sample table?

Best Regards,
Angelia

[Anonymous · Accepted solution]

Hi @v-huizhn-msft,

I already solved the doubt with calculate and filters. I have made an auxiliary table with the unique values of the accounting accounts and there I calculate the data I need from each of them.

Thank you very much and best regards.

[v-huizhn-msft]

Hi @Anonymous,

Congratulations, you have resolved your issue by yourself. Please mark the right reply as answer. More people will benefit from here.

Best Regards,
Angelia