Greatest by grouping i.e sql=> sum ... group by

[#1]

  Hello Everyone,

I have a chart as the one that's pictured.  It's a Sales vs Month chart.  What I would like to do is find ask the following question using Set Analysis: "Given the current selection, find the greatest "sales by month" value."

I know what I would do in SQL, which is I would SUM over Sales, and then GROUP BY Month, Blah, and Blah.  But I'm know that won't cut it here.

Any help is greatly appreciated.

[Gysbert_Wassenaar · Accepted solution]

max(aggr(sum(Sales),Month))