Does anyone have experience applying a summary type of maximum to a formula (text) field that is a dense_rank function inside a case statement? I'm pretty sure I have to apply max() to portions of the formula in order to get it to summarize without error, but I can't figure out where exactly I have to do it.

case when (dense_rank() OVER (PARTITION BY {field1} ORDER BY {field2}))=1 then {field3} else null end

. The fields are all on a custom record: field1 is a reference to another custom record, field2 is a way to order, and field3 is text. The goal is to have the field3 in columns instead of repeating rows based on it's dense_rank. There can be up to 6 returned, and my formula columns have =1, =2, =3, etc. Getting them into columns works, however I'd need to use a summary type of maximum to remove nulls where applicable, and to get all values on a single row.