Common Calendar issue

[arpitkharkia]

Hi All,

I have 3 transaction tables which link up with each other associativity based on a mapping table. I have attached the spreadsheet which contains the transaction tables and the mapping table.

My problem is that i am not able to create a common calendar for the dates present in the transaction tables. I saw a few solutions on the community but still unsuccessful in implementing those in my scenario. Please let me know if there is any confusion in understanding this scenario, i will try to create an app.

Any kind of help and advise will be appreciated. Thanks!

Regards,

Arpit

[Arthur_Fong]

Concatenating those 3 transactions table seems to be a better way of doing this:

Then, you can select the transactions you would want to view(1,2,or 3), which is the result of concatenation of the 3 transaction tables using the same column name.

MasterCalendar is created once the tables are concatenated together.

Refer qvw attached as reference.

Thanks and regards,

Arthur Fong

[Brett_Bleess]

Arpit, did Arthur's post with his sample app get you what you needed?  If so, do not forget to come back to the thread and use the Accept as Solution button on his post to give him credit and let others know this worked.  If you are will working on things, leave an update.

Regards,
Brett