2 Replies Latest reply: Oct 30, 2013 9:32 PM by CheongWeei Gan RSS

    Question on Set Analysis interaction with user selection

    CheongWeei Gan

      I have a table like this

      DeptTypeManager
      FinanceTempA
      FinanceEmployeeA
      FinanceEmployeeB
      FinanceEmployeeB
      FinanceTempA
      SalesTempC
      SalesEmployeeC
      SalesEmployeeD
      SalesEmployeeD
      SalesEmployeeD


      and I would like to show in text field the % breakdown by Employee Type for a department

       

      I use this formula to compute the % :

       

      % Employee in Sales dept : Count({$<Dept={Sales}, Type={Employee}>} Type) / Count({$<Dept={Sales} TOTAL Type) = 4/5=80%

      % Temp in Sales dept        : Count({$<Dept={Sales}, Type={Temp}>} Type) / Count({$<Dept={Sales} TOTAL Type) = 1/5= 20%

       

      So far so good.  However, when a selection is made on the Type listbox, , the above computations no longer work. i.e. if I were to select Temp in the Type list box, the above computation will show 400% ( 4 /1 ) and 100% (1/1) when the correct result should be 0% and 100%.

       

      How do I modify the set analysis formula to take into account the selected value ?