Filtering a module to only show non-zero entries

Options
Kelsey_Tweedy
Kelsey_Tweedy Member, ALL USERS, Community Member Posts: 1 New Contributor
in Planning & Modeling

Hello

 

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? 

Tagged:

Comments

  • daniel_ellis
    daniel_ellis Member, ALL USERS, Partner, Certified Model Builder, Community Pioneer Posts: 5 Master Anaplanner of the Year

    Perhaps you could share a bit more information:

    - Could you share a screenshot of your module view?

    - Could you confirm whether your list running along the columns has a top level parent?

     

    Thanks.

Categories