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

    Total on N Firsts (in lines and columns)


      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,