Hi all,
i need help to create a calendar linking on multiple dates.
i have 2 fact tables that have been concatenated into 1. the first one (Data1) needs to link on an 'Date Invite Sent' field but the 2nd one (Data2) needs to link on an 'End Date' field.
what i want is for a user to select a date , lets say 'Year' = 2017.
then a chart to display the sum(Value) for data1 for 2017 based on Date Invite Sent and then another row showing the Sum(Value) for Data2 for 2017 based on EndDate.
i have attached an example.
for my example, the results i am looking for is the following..
| Year | DateType | Value |
|---|
| 2017 | Data1 | 39 |
| 2017 | Data2 | 10 |
any help would be appreciated.
