Identify same value in the dimension

[#1]

Hello,

I have this chart table. My problem is that i have to kind of quarters, one for forecast and one for actual, and i am not able to relate both.

Year	Quarter	Quarter Cruise	FORECAST	ACT
2015	Q1	Q1	419	118
2015	Q1	Q2	419	322
2015	Q1	Q3	419	628
2015	Q1	Q4	419	268
2015	Q2	Q1	1.228	118
2015	Q2	Q2	1.228	322
2015	Q2	Q3	1.228	628
2015	Q2	Q4	1.228	268
2015	Q3	Q1	1.849	118
2015	Q3	Q2	1.849	322
2015	Q3	Q3	1.849	628
2015	Q3	Q4	1.849	268
2015	Q4	Q1	936	118
2015	Q4	Q2	936	322
2015	Q4	Q3	936	628
2015	Q4	Q4	936	268

What i need is to find the solution to build this chart. How can i do it?

q1=q1, q2=q2, q3=q3,q4=q4

Year	Quarter	Quarter Cruise	FORECAST	ACT
2015	Q1	Q1	419	118
2015	Q2	Q2	1.228	322
2015	Q3	Q3	1.849	628
2015	Q4	Q4	936	268

Thanks

Belén

[Gysbert_Wassenaar · Accepted solution]

Use an if statement to check if the quarters match. See attached qvw.