8 Replies Latest reply: Jun 15, 2017 6:07 AM by Kamal Kumar Sanguri

# Grouping dimension wrt their values

Hi Everyone,

I've to create chart as shown in the below image however, these are 3 different dimensions viz., Country, Zone and Branch respectively.

How can i group the values at each dimension and show them as 3 different bars in a bar chart? Please advise ASAP.

Regards,

Zain Shaikh

• ###### Re: Grouping dimension wrt their values

Not sure I understand, can you post some sample data records and your expected result?

In general, you can create a bar chart without any dimensions, just create some expressions, one for each bar.

• ###### Re: Grouping dimension wrt their values

I just got this as a mockup and don't have sample data (only image received)

On the Y axis, it's the Market size values which is then consolidated at each Country, Zone and Branch level.

The y axis is hidden in this chart. Could you please try to help me out.

Thanks,

Zain

• ###### Re: Grouping dimension wrt their values

Hello, Zain!

If you have field which indicates what is "Country" and what is "Branch" so use it as the dimension in a bar chart.

If you don't have such field you can use three expressions with set analysis:

sum({<condition1>} val), sum({<condition2>} val), sum({<condition3>} val) and name them Country, Zonal, Branch.

Or you can create a phony dimension using ValueList() function and set expressions for each value in it

• ###### Re: Grouping dimension wrt their values

I think you are looking for something like this, Please refer attached.

• ###### Re: Grouping dimension wrt their values

This looks like the solution i required.

Could you please explain the solution in written format. The reason is i'm working on a non-licensed application currently and won't be able to open this file.

Sorry for the inconvenience. Thanks.

• ###### Re: Grouping dimension wrt their values

Expression :

1. Sum({<Year=,Month=>}Sales)

2. Sum({<Year=,SalesMan=>}Sales)

3. Sum({<Month=,SalesMan=>}Sales)

• ###### Re: Grouping dimension wrt their values

Just create three expression:

Sum({<Year=,Month=>}Sales)  - > This will avoid bar to change if any selection is made for Year,Month

Sum({<Year=,SalesMan=>}Sales) - > This will avoid bar to change if any selection is made for Year,SalesMan

Sum({<Month=,SalesMan=>}Sales) - > This will avoid bar to change if any selection is made for Month,SalesMan

You will need to replace your fields which Year, Month & Sales.

Now, Just press one space in Label Box to clear the expression coming on chart as title.

Since, we have not used any dimension you will not see labels below your bars. Now, to create those labels use text objects type your text make them transparent (Set the Transparency property to 100%). And then Place these transparent objects below their respective bars.

One more thing you have to set the Layer to Top for the text objects otherwise they will go below the chart and will not be visible.

• ###### Re: Grouping dimension wrt their values

You don't even need a dimension, just add three expressions, for example

Sum(TOTAL <Country>  fieldname)

Sum(TOTAL <Zonal>  fieldname)

Sum(TOTAL <Branch>  fieldname)