Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Can someone please help?
BEFORE (table1):
Room - a field from database table
Start Date - a field from database table
End Date - a calculated field based on the calculation
AFTER (table2): (what I want to be in QV)
Date - 10 days starting from today's date (assuming today's date is 28/06/2016)
So if you think this is a course where students are arranged in what room from what date (start) to what date (end):
Different examples:
Any helps would be much appreciated!!!
Thanks,
Olivia
I think you need to match your start- and end-date with a master-calendar per IntervalMatch and then you could use room and date as dimensions with an expression like: concat(People, chr(10)).
- Marcus