View the original community article here
Last tested: Jul 8, 2019
Try using this table calculation:max(pivot_row(${name_of_measure}))
That will return a single column with the largest value in each row!
This content is subject to limited support.
How do I return the largest pivoted value in each row? (Community)
