Finding the last non-zero value in each column
I've got a DataSet with several columsn. Each column stores a single statistic:
There are many rows, each of which has each column along with data, location name and other values of interest.
Here's the question: Sometimes rows have 0's that indicate 'no change'. What we're after is a chart that uses the last non-zero value in each column as the data for the plot. There's a timestamp in each row, so it's not hard to figure the order and what "last" might mean.
The problem here is that we're not going to find the right value for each column in the same row. So, I can just get the last row. Also, the value won't always be the MAX or else I could use that.
Is there a clever beast mode that might help out here, or do I need to rework my DataSet?