For your other purpose, just make sure you set the table to "No filter". Alternatively, you could build two filters: one named "Include Blanks", and one named "Exclude Blanks". Then when open the model, you set the exact filter you want (it's self documenting to boot!).
Additionally, you could save two project files, each having the filter name as part of the project filename so you know which does which. If you do this, just make sure you've set the right filter before you save the project file.
Other than creating a new model and a new table is there another way?
Thanks /b[/quote]Hi Neil,
Should not be a problem. Although Kruncher suggested opening the table window to define the filter (which is where you can access the menu under the DATA label) the filter does not have to be applied to the table, just apply it to your summary. (However it will be automatically applied when you define it so you need to set it back to no filter, or whatever you need, before leaving the table. Remember there are a number of places that allow you to select and apply filters you have already defined - assuming you are using one of the most recent versions of Monarch of course. I have to admit I don't recall if you have provided that info before. Apologies if you have.)
Have multiple versions of the same summary, created quickly using the DUPLICATE option, each with a different filter - if you have the need.
In fact if you are using Project Exports you don't have to apply the filter to a summary at all as long as it is defined. You can just use the apply all filters option on export ...