Skip to Content

how to sum particular dimensions in design studio?

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jan 24, 2017 at 11:58 AM

    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

    Add comment
    10|10000 characters needed characters exceeded