2 Replies Latest reply: Aug 9, 2018 1:22 PM by sahiba kaur kohli RSS

    Need help in creating output table

    sahiba kaur kohli

      Hi All,

       

      I have the following input table, in which I have sales for Nation, Region and its respective territories. I need the output in the following format: (Here I will add a filter of territory, so depending on which territory is selected it will show its sales, it respective regions sales and nation sale in one table. Also, the respective contribution of territory in that region, and contribution of region in Nation.)

       

          OutPut

      AreaSales% Contribution
      T111911%
      R1   1,126 41%
      N   2,749

       

       

      The input table is:

         

      Input
      NationRegionTerritorySales
      NR1T1119
      NR1T2116
      NR1T3164
      NR1T4198
      NR1T5137
      NR1T6110
      NR1T7124
      NR1T8158
      NR2T9140
      NR2T10200
      NR2T11119
      NR2T12127
      NR2T13186
      NR2T14107
      NR2T15174
      NR2T16198
      NR2T17141
      NR2T18118
      NR2T19113

       

       

      Appreciate your help.

       

      Thanks