7 Replies Latest reply on Oct 17, 2018 11:49 AM by Deepak Rai

    Comparing multiple measure values

    Peter Hanges

      Hello,

       

      I'm trying to do something pretty simple - Compare actuals vs. targets.  My problem is that I need multiple measure values on the same crosstab.  Here's how my data is structured:

       

      Leads
      OpportunitiesActuals/Target
      500100Actuals
      600150Target

       

      Here's what I want the end result to look like:

       

      Actuals
      Target
      % Attainment
      Leads50060083%
      Opportunities10015066%

       

      Any ideas? This is seems like it should be pretty simple