6 Replies Latest reply: May 1, 2013 7:31 AM by Thomas Jensen RSS

    select possible and exclude set analysis

      Hello

       

      I dont know if i am able to do this.

       

      I have a Funnel chart where i have a count of companies from my listbox Milestone.

       

      Can i include a value in my expression so i would get values from my listbox phases

       

      I am thinking something like this?

       

      =Count({$<DimSalesPhases.Milestone=e({$<DimSalesPhases.Milestone={'UKENDT'}>} DimSalesPhases.Milestone),

      DimPotentialCustomers.RelationID=p({$<DimPotentialCustomers.RelationID={'11'}>} DimPotentialCustomers.RelationID) DimPotentialCustomers.Company)

       

       

      So first im excluding a value from milestone (that works fine if i only have this) But next i want to include a valaue from another listbox - but i cant seem to figure out the expression?