Forum Discussion
Solved
Data maniplulation after grouping
Happy Friday! I am trying to extract data specific for each group from one column in a table based on finding the maximum value in another column. I have the following setup Key = column by ...
try using this M-expression
then expand column records:
You can just add a MAX operation on the Value column right from the Group function GUI. Also add an All Rows column. That should give you what you are looking for. You'll have what you need to then add the average column.
--Nate