7 Replies Latest reply on Sep 16, 2019 10:08 AM by Gerardo Varela

    Create a top and group the rest in "others"

    Maxime Huot

      Hi guys,


      I'm having some issues with a table I am creating. For info the table contains various parameters so you can switch what you see between the x  ; y  axis.


      On the photo you can see what I have and what i need.

      I would like to keep only the first five columns (A;B;C;D.E)

      BUT I also need to keep a 6th column called "others" which would regroup the rest (in this case "Others" = F; G; H; I")



      What I have:



      What I need:




      Do you know how I can get this result?


      Unfortunately i cannot share the workbook


      Thank you in advance,