3 Replies Latest reply on Jan 3, 2017 3:33 AM by Akram Ebrahim

    Date filter across different sheets

    Yash Chaturvedi

      Hi,

       

      I have 3 data sheets- suppose: A,B,C and i've joined these 3 sheets taking A as master table.

       

      I've date field in B which i'm using as a filter in the same sheet and have another date field in C which i'm using as a filter in that same sheet (Working fine)

       

      Now, i want to use the date field from sheet B as a filter on sheet C data && similarly i want to use the C sheet date field as a filter on sheet B data.

       

      I've tried it but not able to get the desired values, A data sheet (Master has also a date field but using that on both B & C sheet values are not coming correct)

       

      Can someone suggest a way how to get it done or is it even possible or not..?

       

      Thanks