18 Replies Latest reply: May 17, 2017 3:10 AM by aurore bec okab RSS

    Set Analysis - filtering a flied based on selections on another field

    aurore bec okab

      Hi,

       

      I'm having trouble writing a set analysis. I want to display the revenues generated by the people from a Business Unit (no matter if it is generated in another business unit) when said business unit is selected.

       

      In other words :

      if my current selection is BU = "A" , then I want sales generated by BU A Salesmen to appear, even if it was generated in BU B

       

      Set analysis should be around : sum( { $ < BU= , BU_Employee= {BU} >}sales)

      but I don't seem to be able to make it work.

       

      Sorry, i can't post my data, it's in french and pretty much tangled with a lot of other info.

       

      Thank you for your help,

       

      Aurore