Showing the period along with max
I've done a pretty straightforward dataflow that sums an amount, gives me some identifying information (location, lcoation#, period).
I can do a table card that shows me the location and the max amount for that location. But, when I the period, I'm getting all values.
I know I need to filter to only show the max value, but I'm not sure. I can't actually do a filter on max value.
Is there some sort of trick to showing the max value for each location and the associated period?