dear all,
I kindly seek your advice i have a fact table and a targets table and wish to find the variance in a straight table, the target is set as a combination of region and product, meaning the same product in region 1 has a different target in region two. the targets do not change so i had the table as dimension i don't know if its correct to do so. have tried this this and it seems to give me correct results im just seeking you advice before implementing this solution at work please see the attached file
