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

Highlighted
Contributor

Re: Pick list item based on property

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.
Message 11 of 13
New Contributor

Re: Pick list item based on property

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

 

Message 12 of 13
Contributor

Re: Pick list item based on property

@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

 

 

 

 

 

Message 13 of 13