2 of 2 people found this helpful
Please see attached. There are table calculations that allow you to simply look up the previous value and use it in your expression. Previous value does depend on how you set your table calculation though.
I wasn't quite sure how to do it with the calculated fields you used, but since you essentially used a count of number of records anyway, I replaced it with that.
Hope it helps you further.
thank you for your help!
If possible, I would like to do exactly what you did but with measures/calculated fields. If that doesn't work, is there a way to convert multiple measures into one dimension as a work around?
Thanks a again.
Sorry it took a moment to get back to you
Not sure what you mean with your question. You can substitute the (sum) number of records for another measure or even calculation. And you can set up the table calculation that does the actual looking up to use different fields to determine what "previous" row you're looking for.
Does that help or could you give a more specific example?
Thank you Dana!
The substitution worked fine. Color indicators don't work for 'Measure Values', but just using the SUM in a 'multiple mark type' chart with your color indicator worked.