Hi The specified item was not found.
Thanks for your response here.
I tried to do this by adding another set of data where the last day for Client ID 12546 is 6. I am not able to generate what you have there. Is there something I may be missing?
Having said that as much as I like table calculations this won't work here as I have over 10 metrics that need this with conditional formatting on them which I will then be using to add to a summary table in the end. I feel like I want to have the data just filter out the last from the raw data as appose to the view if that makes sense? Or otherwise maybe it would be best to change my back end data to just show the last number and all others to be 0 and sum that.
What do you reckon?
Date as of yday-154898-kk.twbx 12.0 KB