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
