Skip to Content
0

how to sum particular dimensions in design studio?

Jan 24, 2017 at 11:10 AM

55

avatar image

In my report i have 2 charts. The first chart contains "region" as dimension and "profit" as measure.In pie chart "Others" contains 3 regions(west,north&northeast).

The 2nd chart contains product category as dimension and profit as measure.

If i m clicking others in pie chart,then 2nd chart shows profit of selected region,

and i m clicking others it does not shows the sum of 3 regions.

My question is how to display sum of 3 regions(i.e others) in 2nd chart?

chartdrill.jpg (18.5 kB)
chartdrill2.jpg (18.5 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Koen Hesters Jan 24, 2017 at 11:58 AM
0

Hi,

in properties of Chart_1 >> on select >>script:

var selection = CHART_1.getSelectedMember("Region");

AA_1.setFilter("Region",selection);

Whereby AA_1 datasource is of your chart_2.

Grtz

Koen

Show 6 Share
10 |10000 characters needed characters left characters exceeded

thank u koen,

i want to display others profit in 2 nd chart.Others part contain 3 regions.But it shows only one region.

0

Hi,

Others is a value of Region, no?

Others has 3 subregions?

Can you show an example of your data, to explain it a little bit more, please?

Thanks in advance

Koen

0

yea sure,

my actual data source is given below,

In pie chart's additional properties,there is a option for data transform,using that option i transformed my pie chart into 3 regions(top 2 regions only displayed in 2 segments and remaining regions aggregated and displayed as others).

thank you

actual-ds.jpg (21.3 kB)
chartppty.jpg (57.9 kB)
0

Hi,

selection mode = multiple I guess, I'm sorry my version has not that feature. But I guess you have to enable that you are going to push through more than one region value. But The filter should remain on region. So you can test it with showing the value of

CHART.getSelectedMembers(REgion);

when you click on others.

Grtz

Koen

0

thank you koen

i tried but it doesn't work.

0

what do you get if you set a text with the selected values

text_setselectedmembers (region)

grtz

Koen

0