A bit of a tangent to the original question, but I think it is valuable to share. I see all the responses showing how to create expressions to address the original question - but they are being shared as screenshots. Did you know you can also share them in their Text version - which not only you can modify directly, as if you were authoring code or SQL, but also copy and past between VA instances? Here is an example. I have been working on the expression below, which is similar to the ones above: But now I will switch to its Text version. Just click on the tab at the top right of the editing area: Next, right-click on it, select all and copy to the clipboard: And here is the final result, as text: ( 'Open+'n NotIn ('CLOSED') ) AND ( ( Year(DatePart(Now())) - Year('Date Opened'n) ) <= 'YearHorizon'p ) If your dataset has matching columns, you can re-create my expression simply by going into a new expression editor and pasting the text above in the Text editing area. Or you can paste it and change variable names to match your data. I even keep a file with my favorite expressions that I re-use in different reports and explorations. Give it a try!
... View more
