Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I have the following problem:
I have 2 straight table charts:
1) Dimension: moth name of "claim_started" from a table
Expression: sum(amount_eur)
2) Dimension: month name of "reserve_date" from another table
Expression: sum(reserve_eur)
What I would like to do is to union somehow this 2 tables, because the dimension names are the same (Jan,Feb,Mar...) even if they refer to different date fields and to keep the Expressions values identically...
EX:
1)
month(claim_started) Value1
Jan 134
Feb 12
Mar 23
... ...
2)
month(reserve_date) Value2
Jan 33
Feb 544
Mar 44
...
And the result table must look like:
month Value1 Value2
Jan 132 33
Feb 12 544
Mar 23 44
...
Thank you very much,
Silviu
Hi Silviu,
Find attached an example document on how to create a link table with a mastercalendar. This will solve the problem for you.
Kind regards,
Henco
You could try creating a master calendar, linking the main table by claim_started and then resident load the same table and link it to the master calendar by reserve_date
You could use a JOIN statement. Something like the following should work for you:
tblTest:
LOAD * INLINE [
Month, Value1
Jan, 134
Feb, 12
Mar, 23
];
JOIN
LOAD * INLINE [
Month, Value2
Jan, 33
Feb, 544
Mar, 44
];
Hi Silviu,
Find attached an example document on how to create a link table with a mastercalendar. This will solve the problem for you.
Kind regards,
Henco
Thank you all for you're help.
I will try to use you're solution, and if it still won't work, I'll post back.
Best regards,
Silviu.
Oké, good luck. Would you please mark the answers as helpful or correct please
Kind regards,
Henco