How to create a "mirrored" bar chart?
in bar charts by default the category axis is displayed on the left side of the chart, and measures are drawn from left. However, I would like to create a "mirrored bar chart", where the category axis would be displayed on the right side (please check the attached screenshot to see what I would like to see).
I didn't find any such option in chart properties.
A trick springs to mind, to create a variable that would multiply the original measure by -1 and use this variable, but this would display negative values both at the value axis and in alt-texts upon hovering the mouse over the measure, so I would rather avoid that.
I'm using WebI 4.1 SP01.
Thanks and best regards,