TOTAL AMONOUT FOR EACH COSTUMER

[Jalal_1988]

Hello my friends

how I can achieve to the total amount for each costumer separately in one column like the excel fiea i shwed the table and the result which i want in power query,

Thank you for your help

[#2 · Accepted solution]

Hi @Jalal_1988 

First you do a double aggregation when Grouping [Customer]:

Then Expand all (but 'Customer') fields from [DATA] and add a custom [SHARE] column

[#3]

@Jalal_1988 

Alternatively, with Power Pivot: