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:

      tempsnip.png

       

      What I need:

      tempsnip2.png

       

       

      Do you know how I can get this result?

       

      Unfortunately i cannot share the workbook

       

      Thank you in advance,

       

      Max