2 Replies Latest reply on Jan 6, 2017 1:57 AM by Sahithya Reddy

    Expansion of hierarchy conditionally

    Sahithya Reddy

      Hi,

       

      Source is oracle for the worksheet.I have a worksheet having Hierarchy field in Rows shelf. Suppose we have hierarchy as below:

      Country->State->Region. Then Country is in the Rows Shelf.

      I have a spreadsheet having a column Limits. Limits have values Yes and No. Yes means 'DrillDown should be done', No means he should not be able to drilldown.

      So, what I need is Yes means, the user should drill down till Region, No means he should see only Country level details.

       

       

      Thanks,

      Sahithya