ShriShank, I looked over your model. There are a number of issues. The categories Department and Dept L2 were not linked. There was a problem with the values list (amount) and the key list (not sure...

View Question# steveb | Answers

I just created a model that had 3,300 SKU's each with sales and unit values over 7 sales channels with each SKU assigned one of 50 possible grouping identifiers evaluated over 36 months. The total number...

View QuestionThis is a flying key (key/lookup pair built on the fly): Sum of Rate = sum(selectlist(Matrix2::Rate,Matrix2::Machine&Matrix2::Part,Matrix1::MachineName&Part))

View QuestionRich, try: Sum of Rate = sum(selectlist(Matrix2::Rate,Matrix2::Machine,Matrix1::MachineName))

View QuestionShriShank I looked over your model. I am not sure what you mean by transferring all the job codes to the Developer View Summary matrix. I see you have a category called Jobcodes that appears to be a...

View QuestionVince, I would think you would be able to calculate a y for any x since you have the interecept and slop. So it would be do-able. Steve

View QuestionVince, I looked over your model and noted that there was 21 million cells which is impressive; however, it was too impressive for my laptop. I tried the solution I described below but I cannot verify...

View QuestionWell, the formating of my diagram did not come out just right but I hope you get the idea.

View QuestionMCashman, As I understand your situation, you are trying to make a matrix that looks like this: Dimension A 1 2 3 4 5 1 X 2 X 3 X 4 X 5 X Dimension A I...

View Question