Calculated Dimension - TOTAL

[sureshbaabu]

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.

[#2]

write this in your expression

dimension= Region

expression=sum(scores)

and in dimension limit--   check the total sum

see attachement

[#3 · Accepted solution]

in dimension limit

check total mode

see attachement

[sureshbaabu]

Hello Vishwa,

Awesome.Thanks a Lot.

I normally do that for table views whenever required. But never realized that we can do it for Graphs.

It worked. Thanks again

[prasad_dumbre]

Hi,

Just remove Total from expression in vishwaranjan's application, else its perfect for your req.

[sureshbaabu]

Yeah!!! Can we sort dimension for the Total Column?

I'm aware that we can write the expression on Sort tab or to pull a column for sorting.

But, Can we move the TOTAL column to the first position in the above senario?

Thanks