1 Reply Latest reply on Mar 26, 2020 3:07 AM by Norbert Maijoor

    How to filter rows based on max value of a column field?

    Aakash Goyal

      Hi,

       

      I have been trying this but cannot resolve this issue.

      I have a data set with few columns. One of these columns is licenses, and i want to keep all those rows where the license value is equal to the MAX(licenses).

      I don't want any grouping just all the rows where the license value peaks to max value.

      Need this really urgently, how should i create this filter?