Moving Columns of Data

3.82K viewsGeneral Discussion
0

Ok, say that I have a category that exists in multiple matrices. However, the same category in different matrices may have different columns of data. For example:

Matrix1:

South Sales Profit
East
West
North

Matrix2:

East Costs Variance
North
West
South

What I would like to do to create a 3rd matrix, with the same category, but showing my own pick of columns(with no changes to the data):

Matrix3:

South Sales Costs Variance
North
West
East

Is there a formula that will drag over just the columns that I want, or is the only option to do a cut&paste?

Thanks!

0
0

Unfortunately, the model that I have has proprietary information which I cannot post. However, if I get a bit of free time, I may be able to put together an example model, which I will post.

0

numberpro,

I don’t think I see what you are doing here, but it seems it might be useful! Could you post the example as a quantrix model?

Thanks.

Philip

0

Ok, after posting my last message, I thought, wait, maybe it already works in the way that I requested. After testing it, yes, it really does :-).

0

Mike,

Thanks for your reply. In a cut&paste move, one issue that comes up is that sometimes, the rows in a linked category may be in a different order. For example:

In the category states:

*Cost*
CA 50
NV 45
AZ 75

*Profit*
AZ 25
NV 15
CA 30

In the above example, sorting by name might not be an option for some reason.

Also, there may be some rows in a category that may be missing values. Then, you want to pull in all the values that exist, plus zero for empty cells. It would be very nice to have a formula like this:

In State [category], Bottom Line = Matrix name:Profit

IMHO, I think it would make sense in using the category function of Quantrix to the fullest by giving us a way to pull data together, irrespective of the order of rows, or missing values, etc.

Thanks!

0

Since there is way to control the value of items by a formula or expression – I think cut and paste is probably your best bet.

If anyone else out there has a different approach to this – please feel free to post.

-Mike