2 Replies Latest reply: Dec 16, 2014 4:56 PM by Michael Totino RSS

    virtual table of running total?

      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