I am newbie here and need some help.. I have multiple date fields, talking bout 30 different date fields in several huge tables, and i need to use them all in our budget table.
I vs tried to concatenat them bu there is too much data and difficult to manage them.. Is it possible create a unlinked calendar and then use that calendar with variables to display the data in a table/pivot chart?
If you have one Master Calendar, it can be linked to one of the dates. So, the question is - what you expect to see by selecting January 2013? Created orders? Cancelled orders? There are several ways to deal with it, depending on what you actually need. For example, create separate calendars for OrderDate, ApprovedDate, etc. Or, create on calendar not conected to anything, and use logic in expressions, comparing any type of date (for example by set analysis) with the selected in calendar.