This content has been marked as final. Show 2 replies
I'm getting a mental block on this, it seems quite a simple problem but I can't get my head around it!
I have monthly totals for a number of years:
I would like to display a table that contains
Month Min(Value) Year
So that I have a list of months from January to December, with the lowest Value for that month and the year in which that monthly value was e.g.
Month Min Value Year
Jan 12 2000
Feb 8 1987
Mar 15 2010
Apr 65 1993
Dec 32 1972
I've tried various combinations of dimensions and expressions, but not getting very far. Any ideas/pointers in the right direction would be appreciated.