5 Replies Latest reply on Jun 27, 2018 4:46 AM by Shruthi B S

    Aggregate measure at different level

    Shruthi B S

      Hi Everyone,


      Could someone help me in resolving an issue that I'm facing with data blending. I have tried to simulate the scenario with sample data and have attached the workbook for reference.


      I have 2 data sources and only one common field between the 2 sources. I have done data blending and created relationship btw Pri & sec sources based on that field which is OPPO NUMBER in this example.

      My requirement is to get aggregated booking amount per "Rep Name". eg., Arun should get $ 14685..  This is possible only when i take "Oppo Number" field from the view.  

      As "Oppo Number" is the only linking field between sources, i get error upon removing that. Is there a way to achieve my requirement.