Filtering a module to only show non-zero entries
I have a module where the rows are line items and the columns are list members. The view I am trying to create of this module is intended to be used so that we can easily identify any data that has been loaded to a combination of product, company, and GAAP/STAT incorrectly. I want to filter this view so that it will only show cells where the line item and list members are not zero.
The line items form the income statement and the list is a Product-Code combination list. I am struggling to find a way to do this in a manner that is efficient and doesn't create lengthy formulas or take up a large amount of space. Any suggestions?