5 Replies Latest reply: Jul 3, 2013 7:30 AM by Suresh Baabu RSS

    Calculated Dimension - TOTAL

    Suresh Baabu

      Hello All,

       

      I need your help with the request below.

       

      Source Columns : Region , Scores

      Values for Region Column: North, South, East, West

       

      I wanted to plot a bar chart to count the Scores on each region.

      My dimension : Region

      My expression: Sum(Scores)

       

      Default Display is:

      X axis -> 4 bars (one for North, one for South, one for East, one for West)

      Y axis -> Sum of the Scores

       

      Requirement:   I want to have 5 Bar’s in the X axis, which shows the TOTAL of all 4 regions. That will be my 5th BAR of X Axis

      Could you please help me in achieving this?

       

      Thank you.