4 Replies Latest reply on Oct 6, 2014 5:56 AM by Warren Holroyd

    Hiding rows with a parameter

    Warren Holroyd

      Not sure if this is the correct approach

       

      I am attempting to construct a spine chart that displays an Area's performance against multiple measures using z-scores calculated by the average and standard deviation of all "Areas".

       

      Currently, it looks like this:

       

      4e4WEm7.png

       

      ...but I want it to only dynamically display the Area chosen by a parameter ("PARAM Area"), so that it looks like this:

       

      rgWkpYn.png

       

      This was achieved by manually 'hiding' the Areas I don't want, but I'm wondering if there's a way to do this dynamically?

       

      Is this possible, or am I going about this in entirely the wrong way?

       

      Applying filters doesn't help as they remove data from the average and stdev calculations.

       

      Where am I going wrong here?

       

      TBWX file is attached.