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 .



      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



        • 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.



                 Territory :



                                'Territory '      as Type

                      from source;


                 ConsolidatedTerritory :



                                '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.