I have this datasource
The org_name and org_id appears multiple times across the column.
I need to output the Org Name and its ID and the sum of the total amount column. They also have to be sorted from highest amount to lowest.
If we base it on the Sample Data Source above, it will need to look like this
Org ID Org Name Sum per Org
13237 BSA Twin 8100
20202 Acacia 7360
11729 The Legend 6600
... and so on...
i grouped the org and group by the org id then I tried using LOOKUP((GROUPBY(SLICE(@A:A;)), SLICE(@B:B;)),!'Column:Org ID',SUM(SLICE(@C:C;))) but it didnt work.
any help is gladly appreciated :) Thanx :)