How can I build this filter without using 4 billion cells!

HTyler
HTyler
in Modeling

My end users want to see transaction level data being pulled into our model with the ability to filter by account code and time. The filter is currently set up as displayed in the attachment, but takes up way too much space in the model. Any ideas on how I can build a smaller filter for this to continue working? Thanks community!

Filter on transaction data.png

Best Answer

  • andrewtye
    andrewtye
    Answer ✓

    Hi - would put the filters in completely different modules. One for each of the dimensions you're looking up against. And then just need to do reference those new line items using lookup and not needing that multi-dimension line item.

    Can also easily add in Users then to that filter module.

Categories