Forum Discussion
Relationship Issue
I have four tables: Sales, Budget, Territory & Calendar Sales captures sales in a retail store by item (may be hundreds of transactions per day) Budget is a budget for sales by day (one...
- As there is no relationship between the budget and sales table, a filter on date type from the budget table will not propogate to sales table
You can either have
1. A third dimension table for date type and create relationships with budget and sales table
2. Extend the date table to include date type as a field and use it in your table
Thanks
Anonymous the reason you are not correct value coz "date type" from budget doesn't filter sales what you are trying to achieve and what is goal here?
You have incorrect and correct screen shots but does't tell what you are after.