Suppose my source file is having data as below from oracle data source(currently in my sample dashboard in the attachment I am using Excel source):
I have created hierarchy Country->State->Region and pulled into Rows shelf and SUM(Sales) into Column shelf.
I have a spreadsheet having column 'Limits' which has values 'Yes' and 'No' as below:
My requirement is when Limits is 'Yes' then she should be drill down in the worksheet (Country->State->Region) based on the user.
If user logged in is Pradhan, the Limits is 'Yes' then she should drill down in the worksheet.
If user logged in is Reeta, the Limits is 'No' then she should not be able to drill down.Only Country should be seen or if you drill down also 'Region' and 'State' values should not be seen.
Sample.twbx 16.7 KB