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.