Hello All,
I've budget information which captured by month and by brand as attached in the excel file.
However I've the sales information at individual product level and capturing the sales information on a daily basis.
I tired to to make the changes like the attached qvw files and concatenated with the fact table but not able to get the sales & budget information at the brand level.
My sales table don't have the brand information and sales table linked to product table which contains the product and brand information.
How to get the data if i want to compare the data by brand.
Regards,
viresh