Stuck with formula referencing another Matrix

Solved5.14K viewsFormulas and Functions

I am stuck in how to create a formula that references another matrix. I think the confusing part is a time dimension that I’ve set up, based on a Quantrix Sample model.

I have a matrix P & L, with a Year dimension (2012..2016), and a Seasonality Matrix, which I use to create a Year.Month Revenue estimate.

I am trying to populate the 2015, 2016 and 2017 Month cells here:

From the Seasonality matrix (below), and I just can’t seem to figure out what the formula needs to look like.

Can anyone point me in the right direction?


Thank you, James! I agree about the Year dimension – I plan to fix that in future revisions.

I really appreciate your insight and assistance.

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

Latest Questions