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:
South Sales Profit
East Costs Variance
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):
South Sales Costs Variance
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 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:
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.