0 Replies Latest reply: Nov 12, 2015 8:11 AM by Yuvraj Killedar RSS

    One Dimension value static & other variable in TOP analysis

    Yuvraj Killedar

      Hi All,

       

      I have this query wherein I need to implement a top 5 analysis in bar chart where one value is static & others vary as per selections.

       

      e.g.: Suppose I have 10 materials as follows.

      -----------------------------------------

      Material    |    Sale

      -----------------------------------------

            Pen     -    40

          Pencil    -    30

          Eraser   -    60

      Sharpener  -    70

          Colors   -    50

        Palette    -    10

      Notebook  -    20

      Textbook  -    100

          Brush   -    80

      Compass  -    90

      -----------------------------------------

       

      I need to show top 5 Sale for Materials as Colors + Top 5 which makes overall 6 values.

      Here, Material = 'Colors' should be constant & Top 5 from remaining  9 materials.

       

      So, as per requirement the output should be in following sequence in a bar chart:

       

      1. Colors      -     50

      2. Textbook  -     100

      3. Compass  -     90

      4. Brush       -     80

      5. Sharpener -     70

      6. Eraser      -     60

       

      Please suggest over the same.