Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Current Period vs Prior Period Status Change

Hi,

 

I have a column "Comp/Not Comp" that I am filtering on for a comparison between two periods of time (Current Period/Prior Period). If I select the Current Period as 2019 and the row item is "Comp" in 2019, but "Not Comp" in 2018, I don't want the filter to apply. I only want to filter out the items if the "Not Comp" applies in the Current Period. I don't want the "Not Comp" status of the Prior Period to affect the filter.

 

Thanks!

1 Reply

  • Icey's avatar
    Icey
    Community Support

    Hi Anonymous ,

     

    What is your data structure and model? How did you filter? Please share us more details, such as some sample data.

     

     

    Best Regards,

    Icey