4 Replies Latest reply on Dec 11, 2016 6:33 AM by jrmy.meliani

    Total on N Firsts (in lines and columns)

    jrmy.meliani

      Hi everyone ,

       

      I have a little problem and i'm stucked on it.

       

      I need to calculate a Total on N firsts, but I don't manage to do it.

      I used an Index fonction as a Calculated Field to keep the 15 firsts countries by Number of records (filter on this calculated field named "Position", 1 to 15).

      When i want to display the Total at the end of the column, this filter doesn't apply and i have my total for the 170 Countries listed instead of the 15 firsts.

       

      I join you the .twbx if needed, you can have a look sheet named "Operation Count by Country".

       

      Thanks a lot for you help,

       

      Jérémy