Hi,
I would like to know if it's possible to display, as a bar chart dimension, the selected value (from a dimension list box) and the nearest values, such as the bigger two and the lower two, respect to a measure.
Example:
Dimension Measure
S1 10
S2 9
S3 7
S4 10
S5 11
S6 8
S7 10
S8 10
S9 10
So, if the user selects S1 the result will be a bar chart with, as dimension, the values: S7 S4 S1 S2 S6 (in this order) and their Masures as the bars.
If user selects S5 the result will be a bar chart with, as dimension, the values: S5 S1 S4.
If user selects S3 the result will be a bar chart with, as dimension, the values: S2 S6 S3.
Thanks in advance for your help!
Elena
