# Category = sum of a group in another matrix

Hi All,

I am attempting to have data entered into categories being the sum of a group name in another matrix

i.e. Matrix 1 has category names that are nominal codes and matrix 2 has category names that are cost types which are grouped by nominal code

I want the sum of the cost types from matrix 2 to appear in the correct nominal code in matrix 1.

Hopefully that makes sense.

Thank you in advance for your help.

QuantrixAuthority Answered question

Without having a model to work with I suggest you look at using @Level function to return the nominal code and use it as an element of a select function.

If you could post a sample model with your setup I think it would help us help you solve your problem.

QuantrixAuthority Answered question