5 Replies Latest reply: Nov 13, 2012 4:10 PM by Jason Michaelides RSS

    Use value from another row in calculation

    Heather Sterk

      I have a straight table with two dimensions, Line Number and Line Description, the expresssion sums Balance. 

       

      I want to create a second expression that uses the Balance sum from the row where Line Description = 'Net Sales' to calculate a percent value.  So, on the row where Line Description = Product Sales it would look something like SUM(Balance) / [SUM(Balance) from Net Sales].  I can't use Above or Below as the number of rows is not static. 

       

      Any ideas?  Thanks in advance for any help.