MAX or SUM With Group BY ID
I'm looking for a Beast Mode formula to create a MAX calculation by ID in my table.
My resulting column should look like column B below.
I already tried a formula with Distinct and MAX but while the formula was valid, my attempt still failed at producing desired results.
Keep in mind that in my scenario, column A is a calculated field already, don't know if that makes a difference.
|ID||column A||column B - max aggregate|