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:




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




      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.