Sort measure on bar chart
PedroFOct 17 2012 — edited Oct 18 2012Hi,
I'm using OBIEE 11.1.1.6 BP1 and I can't seem to be able to sort a bar chart by my measure value. I created a simple report with the Sample Sales subject area just to exemplify my problem. I have selected Year, Product Name and #Orders as my measure and then added a sort ascending on the measure column.
If I use my measure in the vertical axis, the year on the horizontal axis and the product in the vary color by section the sort isn't applied. The sort is only applied if I place both dimension columns on the horizontal axis (see link with image). Any reason why this doesn't work the way I would like?
https://www.dropbox.com/s/7sphhvq34knwh29/sort%20bar%20chart.jpg
Thanks,
Pedro