Forum Discussion
Anonymous
6 years agoNot applicable
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
- IceyCommunity 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