Hi,
I would like to show the increase of median TTR compared to the previous grade. I have created a measure in PowerPivot to show the median. Grades are incremental from 5 to 14, but I will be making cuts where we don't have all of the grades, so for example, for a group, we might have grades 5,7,9 and 13. In these cases I won't need to show the increase.
Row Labels Median Median increase
05 9.825
06 18.049 84%
07 20.340
08 37.235
09 44.190
10 40.862
11 67.583
12 149.032
13 155.795
14 455.018
16 259.000
Is there a way to do it?
Excel file attached.
Thanks!
Bookmarks