In Mac Excel, to use the dropdown menus you need to hold down the mouse button, not just click it like usual. Also, due to a bug in Mac Excel, using the scroll bars in dropdown menus does not work properly. You can still select any metric/dimension, it's just more difficult to locate it. Microsoft will hopefully fix this soon.