In Qvw you can see ,I select one Brand i.e. 'A' ..
Please check Double Dimension Chart First bar : It should show the data of 5 months from Sep12-July12 but it is showing data from Mar12-Jan13, which is wrong....As Oct,12,Nov12,Dec12 has no data....
I want that each bar should show 5 months data only,in case some months has its data or not..
When I Select Brand 'A', I see the Sep12 - Jan13 Data. (you mentioned Mar12-Jan13)
I think, the Actual sum value from Mar12 - Jan13.
I don't have an idea how to display that range in the dimension, Because Your expression says the Date Range as >=Jan-13 and <=Dec-13. When we put the addmonths(MonthYear,-4) in the Dimension-> This will actually goes Previous 4 month. This won't check Possible value of not.
Regarding your data model,
I Suggest you to Just Link the Cal_Date from the Sales Table with your Master Calendar. You linked Month, Year and day.
I modified the script little bit. You can use, if it suits you..
Create a Other Thread for the calculated Dimension range Month problem. you will get More suggestions.