I have a straight table with Person as a dimension and several expressions. I would like to add a new expression that computes "% of Clients making up 80% of Revenue"). Is this possible? Person, Client, Revenue are the applicable fields.
To do this manually, I would sort each Person's Client list in descending order by Revenue, create a running sum, divide by Person's total revenue, and count until >=80%. Seems like I need multiple aggrs for this to work, but I can't get close...thanks