2 Replies Latest reply: Jul 17, 2015 1:26 AM by Gysbert Wassenaar RSS

    Value for specific dimension if similar to another dimension

      Ok, this one is giving me a hard time.

       

      I'm trying to find a way to find the value for a dimension if it is similar to another dimension.  I have the following set Up...

      image.png

       

      So for Part 1 of my question.  How can i get only the "Member Reported Spend" for a given "Contract Name" if it matches the '=agg' column (i.e. the Spend for 3m Company for Adhesive Skin Closures - "3M COMPANY")? 

       

      I've tried variations of sum(agg(wildmatch....and can't seem to quite get it.  Any suggestions?