I have two tables one fact table with SalesManID,TDate and ActualSales($). Now there are some sales man who dont have some months of data for their IDs
| SalesManID | TDate | Year | Month of TDate | ActualSales($) |
|---|
| 1 | 12/22/2018 | 2018 | Dec | 10 |
| 1 | 11/23/2018 | 2018 | Nov | 10 |
| 1 | 09/20/2018 | 2018 | Sep | 10 |
| 1 | 09/20/2018 | 2018 | Sep | 20 |
| 2 | 12/20/2018 | 2018 | Dec | 20 |
| 2 | 10/20/2018 | 2018 | Oct | 20 |
| 2 | 08/20/2018 | 2018 | Aug | 20 |
| 3 | 08/10/2018 | 2018 | Aug | 20 |
| 3 | 10/24/2018 | 2018 | Oct | 20 |
Plotting the above on Line Chart against ActualSales as Metric on Y Axis and TDate on X Axis primary dimension/ first dimension and SalesManID as Second Dimension. Now for each of the IDs I want to see all the Months. Say for For ID 1 I want to See Sep Oct Nov and Dec. For ID 2 I want to see Aug Sep Oct Nov Dec etc. but ryt now for ID 1 I am only seeing Sep, Nov and Dec as data has only those values. I expect to see 0 values for Aug, and Oct for ID 1.
Thanks in advance
Ram Marthi
