I am trying to display the min and max # of leads (by store) for the selected region.
Dimensions are REGION and Store, the metric is metric is the sum(leads)
The desired end result will show the user for THAT region the MAX Leads by store (for that particular region), and the Min leads by store (also for the particular region) and where the store selection fits on a guage.
I tried playing aggr() but i couldnt figure it out. When i make a selection, the max is always just a sum(Leads) and matches the store selection.