Forum Discussion
GFire
Helper I
Helper IMatrix Year vs Year
Hi, From the attached dataset, create the image matrix. Please. Dataset: https://docs.google.com/spreadsheets/d/1UpU-BSpuBebzvAelfOPYFwBqZZWTv085/edit?usp=sharing&ouid=111608555157032384060&rtpof=...
Hello, and thank you for your interest. I just solved the problem. In the link above, I've added the .pbxi file with the solution. There you can see how I solved your problem with the year columns.
gmsamborn
Super User
Super UserHi GFire
Can you explain how you have Year on both rows and columns but there is only one Year in your table?
I'm not sure how you would be able to create your expected matrix with Year on both rows and columns.
The result would give you a diagonal line of values in your matrix. I'm not sure how useful that would be.
GFireHelper I
Helper IHello, and thank you for your interest. I just solved the problem. In the link above, I've added the .pbxi file with the solution. There you can see how I solved your problem with the year columns.