2 Replies Latest reply: Jul 11, 2018 12:54 AM by ishan Bhatt RSS

    Summing on multiple values

    Imran Syed

      Hi Experts,

       

      I have a territory No(Field From Dim table) and   consolidated territory no(Field from Fact table).

       

      So I want to display the Sum of sales for  consolidated territory no but display only the Territory No .



      Example:


       

      For Consolidated Territory No: 200

      we have Territory No --200,217.


      So when i pull Territory No in pivot it should show 200 but the sum shd be for 200+217


      Appreciate the help



      Cheers





       

        • Re: Summing on multiple values
          Chennaiah Nallani

          Can you share sample data

          • Re: Summing on multiple values
            ishan Bhatt

            Hi Imran,

             

            In this scenario, you can add a field in both tables something like Type.

             

            E.x

                 Territory :

                      Load

                                field1,

                                'Territory '      as Type

                      from source;

             

                 ConsolidatedTerritory :

                      Load

                                field1,

                                'ConsolidatedTerritory '      as Type

                      from source;

             

            Now when you want to create a sum of any field then add set analysis.

             

                 =Sum({<Type = {'Territory'}>} field1)

             

            Hopefully, this will solve your problem.