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
Ashish_Mathur
Super User
Super UserHi,
In the Calendar Table, create a Day Type column and drag that column in your visual.