I have already created time data which I am using as base for my time dim
Year 2009 2010 2011 2012 2013 2014 2015 2016Time Dim
I have another table A which has following column
Year Contract NO Amt 2009 1234 400 2012 1234 300 2013 1234 800 2015 1234 100 2016 1234 600 2017 1234 100Table A
I can do right join and get all the years but I need contract no and amount as 0 where match doesn't exist and I want to get in graphical Calculation View, if it was script then i could have used cursor
Result
Year Contract NO Amt 2009 1234 400 2010 1234 0 2011 1234 0 2012 1234 300 2013 1234 800 2014 1234 0 2015 1234 100 2016 1234 600 2017 1234 100Please help