1 2 Previous Next 18 Replies Latest reply on Feb 21, 2020 11:40 AM by jonathan.rajbahadursingh

    2 filters in a worksheet

    jonathan.rajbahadursingh

      Hi,

       

      How can I apply two filters in my worksheet? 1 would be choosing the months, 2nd would be choose the day in the months of whats chosen in the first filter.

      Ie below I have Jan 31st 2020, to Oct 31st 2019. I would want to display all values between this range from "day" in my worksheet.

       

      1st filter - asofdate

       

       

      2nd filter - Day.

       

       

      Sample Data:

       

      day             value         asofdate

      +------------+--------+       ------------+

      | 20191001   | -13492 | 31/10/2019 |

      | 20191002   | -13446 | 31/10/2019 |

      | 20191003   | -12702 | 31/10/2019 |

      | 20191004   | -13427 | 31/10/2019 |

      | 20191007   | -12573 | 31/10/2019 |

      | 20191008   | -11984 | 31/10/2019 |

      | 20191009   | -14738 | 31/10/2019 |

      | 20191010   | -13568 | 31/10/2019 |

      | 20191011   | -13676 |                   |

      | 31/10/2019 |             |                   |

      +------------    +--------       +------------+

       

      any help would be appreciated.

        1 2 Previous Next