Table With Max Value for Dimension Name

[m_perreault]

Hi All,

I have the below tables

Region	Revenue
North	100
South	200
East	300
West	400

Department ID	Revenue
1	200
2	300
3	400
4	75
5	25

I'd like to create a table that has just the name of the Dimension and the max % of Revenue for that dimension and the Dimension value that is the max such as below

Dimension	Max Revenue Share	Dimension Value
Region	40%	West
Department ID	40%	3

Does anyone have any ideas?

Thanks,
Mark