Pick list item based on property and use it as a dimension/LOOKUP

[visivasa]

Thanks @DavidSmith! I think the original solution proposed here is similar, wherein we use a list with the summary set to "Last Non Blank" that does the trick.

[Ms_Peach]

What's the complete formula that ends with ITEM(Average.... in Curve module? I'm getting error in formula.

[visivasa]

@Ms_Peach 

Its just

" .... ITEM(Aging Bucket) ELSE BLANK " 

The blank is necessary as the summary method for this line item is set as "First non-blank" which is a key part of the solution provided by LipChean_Soh