3 Replies Latest reply on Aug 22, 2018 6:58 AM by Ankit Patel

    Comparing Multiple Measure Values

    Peter Hanges

      Hi all,

       

      I'm trying to replicate the following table from Excel:

       

      ActualsTarget
      % Attainment
      Leads50060083%
      Opportunities15020075%

       

      The problem is that there are 4 measures here, as well as a calculated field. 

       

      1.  Actual Leads

      2.  Actual Opportunities

      3. Target Leads

      4. Target Opportunities

       

      Actuals come from one dataset, while Target comes from another and they are blended on common dimensions.  Any ideas?