100% Stacked bar chart with Drilldown dimension

[Eshwar1]

Hi All,

I have created 100% Stacked bar chart with 2 dimensions and 1 measure

Dim: Div_code, Region

Exp: Sum(Value)/Sum( Total <Div_code>Value)

the chart is displaying as expected.

but the client want to have a 100% stacked bar chart with drilldown dimensions

Div_code and Branch_code (Drilldown dimensions)

once we click on Div_code on Stacked bar chart its should show Branch_Code details with 100% stacked bar

is it possible ? if yes can you suggest the process.

-Thanks

Eshwar

[F_B]

Hi @Eshwar1 , yes it's possible.

Click on the Master Items on the left-hand side.

Select Dimensions and then click Create new.

Choose Drill-down and add Div_code as the first dimension and Branch_code as the second dimension.

Name your drill-down dimension appropriately and then add it to the chart.

Hope this is helpful

[Kushal_Chawda]

@Eshwar1  You could add branch_code in your expression which should work fine.

Sum( Total <Div_code,branch_code>Value)