6 Replies Latest reply on Feb 6, 2019 8:53 PM by Zhouyi Zhang

    joining 2 tables with different levels of aggregation

    Jhanvi Hegde

      Hello,

       

      I have a dataset with 2 different levels of aggregation (please see attached). The tabs are sales and profit. For each account, I would like to show the sum of sales and profit next to each other at the account level as shown below.

       

       

      IDSalesProfit
      AAA455000
      BBB201000
      CCC354000
      DDD303500

       

      Thanks for your help!

       

      Regards,

      Jhanvi