Retaining data form data filters

Summary

There is the option to filter data on a data form by an amount but the filters are not retained when the form closes

Content

Hi all,

I have a requirement so only show data on a form with a data range. This is not data validation rules, but actually applying a filter when the form is open. You do this by right clicking on a row or column member, selecting filter and filter again. Options then appear. It is possible to retain filters applied? Please see the attached image.

 

Many thanks,

 

Nathan