Forum Discussion
Dymanic data source
Hi,
The forecast table (Table B) should have 2 date columns - one which tells us the month for which the forecast is and another which tells us the Month in which the forecast was prepared. Using the USERELATIONSHIP() function, we should be able to get what you want.
"a bit clumsy" is a nice way to put it. I think it is irresponsible for your business requestors to ask you to create such a challenging report with the current experience. Try to work on the issue piece by piece. Starting with the 23 tables will get you nowhere. Start with Ashish_Mathur 's suggestion.
Hi Ibenlin and Ashish,
Really appreciate your help on this and advice above. It is really helpful and give me good directions of what to do next. Hope you have a great day!
Kind regards,
Janis
You are welcome.