I'm trying to create the table above. Group and Item are dimensions. % is a measure calculated as the average value of binary column at the item level. How can I create the Max% column where it shows the maximum % of each Group?
I feel like it should be an aggregation function, but i'm really struggling to get anything to work. Any help would be greatly appreciated!