Separate Chart for different Region

[Anonymous]

Hi,

I am having two Regions (Us & Canada). I want to have two separate chart for each reason showing respective data at same time.

Currently When I am adding If condition to the dimension it restricting the chart display until I select one of the region in the list box.

My data chart is displaying Monthly sales for 3 key products (so there are three trend line).

So the purpose it to view monthly sales for each region side by side on two Separate chart.

Hope someone can help me with this.

Thanks,

[vishsaggi]

May be try this in your calculated dimension like below and supress when value is null for that dimension.

= Aggr(Only({< Region = {[Canada]} >}Region), Region)

OR

= Aggr(Only({1< Region = {'Canada'} >}Region), Region)

[trdandamudi]

See if the below helps:

[Anonymous]

Thank you Thripumala, It did work for me.

Now if I also have division "East & West" for both country and want to have 4 charts. Is that possible.

I have Modified load according, to the file you attached earlier.       

[trdandamudi]

See the attached file and hope this helps:

[Anonymous]

No actually I mean 4 different chart with following.

1. US-West

2. US-East

3. Canada-West

4. Canada-East

I am sorry if I was not clear last time.

[trdandamudi · Accepted solution]

No issues and please see the attached. If you think your issue has been resolved then please closed the thread by marking correct answer, So that it will be useful for others also.

[Anonymous]

Perfect. thank you.

[trdandamudi]

You are welcome,,,