1 Reply Latest reply: Mar 26, 2015 3:20 PM by Elena Prandoni RSS

    How to display nearest value in a dimension

    Elena Prandoni

      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