5 Replies Latest reply on Feb 25, 2013 3:26 PM by Eric Wilson

    How do I apply filter on a sheet using a value that is hierarchically associated with a parameter?

    Eric Wilson

      Let's say I have a heirarchy of Level 1 --> Level 2 in my data set. For example's sake, Let's call it Solar System --> Planet.

       

      I have a parameter on the report for planet, so that in some of my sheets, I can filter the data to only show records at a particular Planet.

       

      On another sheet, I want to only show records in the Solar System of that planet (e.g. A list of all the planets in that solar system and their relative sizes).

       

      How can this be accomplished?