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.
