16 Replies Latest reply: Feb 9, 2018 1:52 PM by TOBIAS LEIVA MORENO RSS

    How to sum range of values

    TOBIAS LEIVA MORENO

      Hi everybody,

      I need your help with this issue:

       

      I just trying to consolidate the values from January to Month-N (N= someone month) as a filter, because I need to reflect the total in a pivot table. Let me give an example with this table:

       

      MONTH= Dimension

      PEOPLE_IN: Measure

      PEOPLE_OUT: Measure

       

      MONTHPEOPLE_INPEOPLE_OUT
      JANUARY150200
      FEBRARY200220
      MARCH178180
      APRIL180190
      MAY190210
      JUNE150120
      JULY170130
      AGOST160180
      SEPTEMBER185198
      OCTUBER190140
      NOVEMBER200130
      DICEMBER110150

       

      If I select January the table show it only the values from January, but if I select March the table should show me the total value from Jan to March (Jan+Feb+March) at the same time the filter should select all months back.

       

      Filter: Jan

      Select Jan

       

      MONTHPEOPLE_INPEOPLE_OUT
      JANUARY150200

       

      Filter: Jan+Feb+March

      Select Jan to March

       

      MONTHPEOPLE_INPEOPLE_OUT
      JANUARY528600
      FEBRARY528600
      MARCH528600

       

      I believe that Sum(Total.....) might be a possible but really I don't know how used and how to do this.

      I hope you can help me.

       

      PD. Sorry if my english have some mistakes...