5 Replies Latest reply: Nov 6, 2014 8:38 AM by Chris Whitlock RSS

    2 Selections wish to have inverse on one only with setanalysis

      Im sure it's easier than Im making it out but I cant seem to get to my answer.

       

      I have data for financial year , organisation and spend value.

       

      FinYear , Org , Value

       

      I wish user to select financial year and a organisation but the table to display :

       

      Selected Financial year but spend value for all organisations other than the selected.

       

      Thank you in advance.

       

      example/

       

      FinYearOrgValue
      2011/12A10
      2011/12A5
      2011/12B10
      2012/13A5

       

      Selection Finyear=2011/12 Org=B

       

      Table to return would be :

       

      FinYearOrgValue
      2011/12A10
      2011/12A5

       

       

      -- Thank you in advance