2 Replies Latest reply: Sep 17, 2014 11:34 AM by Carlos Pacheco RSS

    Common value within a dimension or Max value within a dimension


      Hi: I have the following data:

      FaseTimeAcum
      Fase105:3410
      Fase105:3511
      Fase105:3815
      Fase105:3917
      Fase205:355
      Fase205:367
      Fase305:3315
      Fase305:3416
      Fase305:3518
      Fase305:3620
      Fase305:3722
      Fase305:3823
      Fase305:3924

       

      This is a comulative table, I need to create a pivot table that shows either of these two options:

       

      1. The max comon Acum for each fase:

      FaseTimeAcum
      Fase105:3511
      Fase205:355
      Fase305:3518
      TOTAL34

      *The dimension 'Time' doesn't need to be present in the pivot table

       

      2. The Acum of the max Time for each Fase:

      FaseTimeAcum
      Fase105:3917
      Fase205:367
      Fase305:3924
      TOTAL48

      *The dimension 'Time' doesn't need to be present in the pivot table

       

      I managed to implement the 2nd option, however the 'TOTAL' would show me the max value (24) instead of the sum of the three, so the aggregation should be sum for it to work.

       

      Please let me know if anyona has any ideas on how to implement either option.... very much appreciated.