Replace a derived value with a label
I need to have the maximum value in a column replaced with it's ocncordant
label.
For example in the following table I need to see Alberta rather than the MAX
value underneath the Jan Column:
Sales by Region
Jan Feb Mar Apr May
BC 45600 50000 48000 52600 54700
Manitoba 45600 44000 48000 48000 46500
Ontario 45650 49000 56000 64500 58700
Saskatchewan 45900 45000 45600 44100 38900
Alberta 55700 48000 51000 54500 54600
|