4 Replies Latest reply: May 3, 2016 6:36 PM by Todd Johnston RSS

    Set Analysis - Penetration

    Todd Johnston

      Hi Community,

       

      I am attempting a product penetration calculation to accompany a map.  What I would like to happen is when I select a particular state, to have the industry penetration for just that state populate.  Long story short, is there a way to add a modifier to the below expression to only calculate based on the state selected.  Its currently dividing industry within the state by total industry across the country.

       

      count(distinct {<Lost={'N'},TotalActiveEmployeesClient=-{'=Len(Trim(TotalActiveEmployeesClient))=0'}>}[ClientNumber])/count(distinct {1<Lost={'N'},TotalActiveEmployeesClient=-{'=Len(Trim(TotalActiveEmployeesClient))=0'}>}[ClientNumber])

       

      Hopefully that makes sense.

       

      Thanks

       

      TJ