Current Period vs Prior Period Status Change

[Anonymous]

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!

[Icey]

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