Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
@Eshwar1 You could add branch_code in your expression which should work fine.
Sum( Total <Div_code,branch_code>Value)