Forum Discussion

bozdemir's avatar
bozdemir
Frequent Visitor
7 years ago
Solved

Calculation (or Measures) for rows

Hello,

I have a table such as the following abd want to add the % row (last row), which is based on the two rows from the table.  Is there a way to do this?  Thanks very much.

Accounts Receivables AgingMonth 1Month 2Month 3
0-30 Day$7.0$11.0$12.0
31-60 Day$8.0$12.0$10.0
60+ Days$5.0$3.0$6.0
Current$30.0$34.0$12.0
Total Open Amount$50.0$60.0$40.0
    
60+Days past due as a % of total amount10.0%5.0%15.0%
  • Thanks, Stachu.  It worked. I did not have to follow all the steps you described.  But now, I have a measure that calculates the % I want.  Thanks again.