SAimple Set anlaysis

[aaronnayan]

Hi Experts

How would i write

To show -

The Highest number of sales (field) made from which City (dimension)?

----------------------------------------------------------------------------------------------

// ie       SUM( {$<Max(Sales )] = {"*"} >}City)??????

Thanks Guys

[isorinrusu]

max({<City={'YourCity'}>} Sales)

[isorinrusu]

If you want to show the max sales of each city, you'd create a chart with City as the dimension and max(Sales) as the expression.

[Ralf_Heukäufer · Accepted solution]

Hello Aaron,

without an set analysis clause i think you can also write:

max(aggr(sum(Sales),City))