Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I've a requirement where I've two charts that using two master dimension as mentioned below(Drill Down1 and Drill Down2). Two charts have drill down and one chart should be one level down. Like from the 1st chart if we select 'State' then in the second chart it should show 'Region' wise data (One level down).
1st chart: Drill Down1: county-->State-->Region-->customer
2nd chart: Drill Down2: State-->Region-->customer-->Project Number
Could someone please help me on this, if this is feasible.
Thanks in Advance
I think in your drill down if you use the formula for each level like:
if(GetFieldSelections(county)=1,State)
if(GetFieldSelections(State)=1,Region)
if(GetFieldSelections(Region)=1,Customer)