View original (French)

Filter two vertical tables on the same sheet

Koelon Posted messages 26 Status Member -  
Raymond PENTIER Posted messages 58228 Registration date   Status Contributor Last intervention   -
Hello,

Is it possible to filter two vertical tables on the same sheet?
I can apply two different filters to each of my tables, but when I filter one, it hides rows that might be important for the second table.

Thank you :)

Configuration: Windows 7 / Chrome 39.0.2171.71

3 answers

  1.
    JvDo Posted messages 1924 Registration date   Status Member Last intervention   859
     
    Hello,

    Could you add a column containing "tablo1" or "tablo2" to differentiate the rows and arrange your tables diagonally in blocks?
    This way, when you want to work on a table, you first filter by the added column and then by the fields of the chosen table.
    In the first row, you will have the fields of each table plus the added field.
    You split your active sheet and vertically juxtapose the 2 windows that you arrange according to the frozen panes.

    Best regards
    1
    1. Koelon Posted messages 26 Status Member
       
      Hello JvDo, thank you for your response, I tried to apply what you explained to me but I couldn't succeed, take a look at what it looks like: http://www.cjoint.com/c/EFspvQQrP7L
      0
    2. JvDo Posted messages 1924 Registration date   Status Member Last intervention   859
       
      Hello,

      I'm surprised, I see 3 tables with the same structure!!
      Put them one below the other and add a distinguishing field.

      Explain a bit why you have this layout. Is there any benefit for you?

      Best regards
      0
  2. Raymond PENTIER Posted messages 58228 Registration date   Status Contributor Last intervention   17 490
     
    Hello Koelon.

    Why are you surprised by the result?
    Filtering means hiding rows: So if your first filter hid row 9, it's obvious that everything in that row is hidden! It's logical, isn't it?

    --
    Retirement is great! Especially in the Caribbean... :-)
    Raymond (INSA, AFPA, CF/R)
    1
  3. Koelon Posted messages 26 Status Member
     
    Hello to both of you & thank you,

    It is indeed logical, but I would like to find a way to filter each table individually.

    Each table will take elements from other tables to ultimately form a logbook. I want to filter this logbook to display only the important elements, making them visible at a glance.

    Do you think it's possible?
    0
    1. Raymond PENTIER Posted messages 58228 Registration date   Status Contributor Last intervention   17 490
       
      Of course! It seems like you haven't read the solution provided by JvDo in post #3!
      0