Limit per Field

Is there anyway to use the 'limit' in the question editor per field top in order to get the top Dim2 for each Dim 1 as per the image below without using a custom query?

Hi @robert.mifsud.bonnic
You can use Max of dim2, Sum of count - grouped by dim1 - example:

Unfortunately that is not what I am looking for. I would like the value of Dim2 where the count is the highest. The solution provided gives the max Dim2 alphabetically.

@robert.mifsud.bonnic You would either have to create multiple sub-queries or use SQL.