3 Replies Latest reply: Jul 23, 2013 8:43 AM by Janes Krige RSS

    Alternate states issue

      Good day,

       

       

      I am busy with a alternate state solution: (Please see attached)

       

      See below for the Alternate states of the objects:

       

      • Sheet:       Default
      • AAA: StateA
      • BBB:  StateB
      • CCC:  Default

       

      The issue is, I need the legend description to change when I select different BS groups (in AAA and BBB).

      e.g. when I select "Nett Income" from AAA, the legend description for the blue line must read " Nett Income " but

      AAA is in "StateA", not the default state like the graph, so I need to use {StateA} in the expression.

       

      This is what I wanted to use:

       

      =GetFieldSelections ({StateA} [ManAcc Definition])

       

      but this is not allowed.

       

      Is there any other way?

       

      Please help...