2 Replies Latest reply: Oct 15, 2011 10:11 AM by diklaelia RSS

    GetFieldSelections

      Hello,

       

       

      My use of GetFieldSelections in the file attached is not giving me what I need.

      I would like to have 3 charts.

      one is with the category per year, second is country per year and the third is the combination of the both.

      when I select only from the category I see what I want to see.

      when I select only from the country I see what I want to see.

      BUT when I select from the category and the country I see at both graph the same result.

       

       

      if it is possible

      I would like to hide the 2 first graphs and see only the 3rd one when I select from country and category. maybe some kind of a recording macro (dont know if it existent)

       

       

      or

       

       

      I would like to have a 3rd graph that showing the combination of the two, but not showing the combination on the 2 first charts like it dose now.

       

       

      Thank you in advance!

      Regards,

      Asaf cadmon via dikla

        • Re: GetFieldSelections
          Deepak Vadithala

          Hi Asaf,

           

          Let me make sure if I have understood the requirement fully. You have 3 chart objects with following information.

           

          Chart 1 : Categories per Year

          Chart 2 : Countries per Year

          Chart 3 : Countries & Categories per Year

           

          Now, when the user selects only Category then you wanted to show Chart 1 and hide other two charts. Vice-versa when the user selects the Country. And only when user selects both Country & Category you wanted to show the both the charts. Is this right?

           

          If this is what you need then I am attaching an example. You need to use the below expression under Layout Tab > Show > Conditional

           

          =GetSelectedCount(Country) > 0

           

          I hope this helps!

           

          Cheers - DV