Forum Discussion
Solved
TOTAL AMONOUT FOR EACH COSTUMER
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
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
2 Replies
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