3 Replies Latest reply on Aug 8, 2018 8:50 AM by Deepak Rai

    % of "Total" when compared to value in field

    Brian Cronin

      I have a field that functions essentially as a subtotal.  What I want to do is compare individual rows within against a value outside of the set.  Data looks like this, even if in the context of super store it doesn't make logical sense.  But I want to Know what Accessories % of Sales /Phone Sales.

       

      Hopefully this makes sense.  It seems like it should be doable, but I can't get my mind around it today.