I'm creating a bar graph that has YEAR_QTR on x-axis and PROD_QTY (a computed field) on y-axis. Now, the requirement is I need to show bars in descending order. If I try to sort it BY HIGHEST PROD_QTY instead of just by Year Quarter it shows an error:
MERGE DIMENSIONS EXCEED THE NUMBER OF SORT FIELDS

If I do the same thing on TABLE, it works fine.

Thanks.

This message has been edited. Last edited by: Kerry,

Nope you can't do that. Here is the solution...Fran Posted COLUMNS is the key.