Filter category in another matrix

5.09K viewsFormulas and Functions


I am new user try to figure out how can I filter my category dimension for cetain values. In the attached model I have several dimensions out of which one is account. I import actual figures into my matrix through Datalink.
I understand that I can only filter to one specific account in the filter pane therefore I want to create another matrix (operational accounts) which only retrieves the operational accounts (6xxxx accounts) and their values in the appropriate dimensions (project, department) of course.
I have already linked this second matrix to my original one, but not sure how can I apply a filter for the accounts to bring all accounts which are less than 70000. (7xxxx accounts are non-operational ones).
I would make furhter calculations/view on this second matrix.
Please note that the accounts in my 2012 actuals matrix could change from month to month (new accounts could be added) as I import the data monthly,
so I would need a dynamic filter for all accounts less than 70000.

Could anyone advise please?



Here’s a idea. Unfortunately, I don’t have time to try this on your model at the moment.

Create a table view on the matrix and then create a filter to only include accounts starting with 6.

Also, is there a way you can simplfy your matrix? The “amount” item seems redundant.

You are viewing 1 out of 5 answers, click here to view all answers.

Latest Questions