Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
My chart has its x-axes having a drill dimension (2 steps) for location and measure is head count.
X axis shows 'Region' at high level which included Asia, NA, Africa etc and on clicking any bar (say for example Asia), I get to see the drilled down chart for Asia region showing the measure for various locations in Asia. Yes, the typical drill down chart.
Now my requirement is...the chart of course will allow the user to click on a region and see the sub region wise split. But I dont want user to click on a sub region to select it again. That is, after the first drill, I want to lock any further drill down attempt. But user should be able to drill up (back) to region level also.
Is this possible ??
Ignore the Sub Region selection in the calculation expression using set analysis. Try changing your expression inline with the below one,
SUM({<[Sub Region]=>}[Head Count])
hope this resolves your issue.
-Haneesh