6 Replies Latest reply on Mar 9, 2017 5:56 AM by Abhishek Yadav

    Want to Calculate sum as per Global Account

    Abhishek Yadav

      Hello All,

       

      I have a requirement in which I want to calculate sum as per global account. Suppose I have global account for NAM region as '100' and for LATAM region as '100la' .

      But when I check for LATAM region and '100la' global account then amount should be only for latam region. but when I check for '100' then my amount should include value for both the account number i.e. amount will be sum of (100la + 100) account.

      Kindly help me on this. I have attached the workbook with sample data.

       

      Regards,

      Abhishek Yadav