i have a table that contains values by month and category and another table which contains month and value
it's not obligatory to have data for a certain category in all months
i'd like to display in a chart all the months and for a certain category, the sum of the values from the 1st and 2nd table. this works fine when this category has a record by month in the 1st table, so if in the 2nd table there is a value for that month, it adds it up. but in case the category doesn't have a record in the first table for a specific month, it won't take into consideration the value for that month from the 2nd table.
can someone find a solution for this without having to change in the script by adding a corresponding record in the 1st table for the missing category/month ?
thx for ur help.
i've attached a sample qvw to clarify my question: for example i want to display for category 'B' the value '10' in january (null from the 1st table and 10 from the 2nd).