you can always create a filter calculation sum(measure)<>0 then place it on the filter sheef and set to True
and that will work when filtering o a single measure - like Lease but your image shows a number of measures are you trying to filter out the entire record when the Lease value is not 0?
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Thank you! I think you understand what I'm looking to achieve.
Basically, for any given year or occupancy type, (could be leased, owned, etc.) if the value in the occupancy type column is 0, I do not want that line to show up.
I will let you know if this works.
So I attempted to do this, and it looks like I have to do it for years 2016-2023. Do I do this all on the same calculated field, or do I have to add a new calculated field for each year?
I attempted to do 2016, dragged it to the filter card, and 2016 disappeared and instead shows up at the end of the table as "Number of Records"
Thanks for the help!