How to find Previous Column values in Matrix

Question

I have a matrix with columns which are dynamically created as the report is run. I need to be able to include for each column after the first one a percentage of the difference between each column and the previous column value.

Something Like

2009    2010    2011    Total

Students    Remaining
Students    Total
Students    Remaining
Students    Total
Students    Remaining
Students
100    NA    80(80%)    20(25%)

How do I pick up the value of the previous column for Total Students in order to calculate the remaining percentage.

I've tried Previous but get an error telling me this cannot be used with matrix.

Can anyone help with this.
Thanks

Answer 1

0

a similar question in the below link.hope you find it useful.

link text

answered Sep 25 '12 at 05:55 AM

aRookieBIdev
2k ● 24 ● 40 ● 46

(comments are locked)

Answer 2

0

I found this answer previously. I've never used code before in a report but I did try and use it and kept getting an error to say that there was no value or similar. I think possibly because not all columns have data in them. I was hoping there might be something simpler. I'll try again with the code. Thanks

answered Sep 25 '12 at 09:32 AM

gaylereihana
0 ● 1

(comments are locked)

How to find Previous Column values in Matrix

Follow this question

Related Questions