I have a simple list, along these lines:
Name %
George 20%
Ryan 45%
Ed 92%
In reality, there are multiple percentages listed for each name (simplified; '%' is actually a calculated value), and I'm displaying the last one. What I need to do, though, is break the list up into sections, like so:
0-40%
Name %
George 20%
40-70%
Name %
Ryan 45%
...and so forth. I've done this by just making each category a separate list with a filter on each specifying the range that the data needs to be in. The problem is that when I do it this way, the report ends up displaying the last value for each name within each category, so I end up with stuff like this:
0-40%
Name %
George 20%
Ryan 12%
40-70%
Name %
Ryan 45%
So what I need is a way to either only take the last values from the database (but LAST() doesn't work in that query) or apply the list filters to just the last values (but LAST() is not allowed there either) or somehow make this one list that is broken up into sections, but I don't know if that's even possible. So how can I do this?