Forum Discussion
Summed values from different tables?
Hi everybody. I have a pretty basic question that I can't find the answer for. I have 2 tables. Let's just say the layout is the following: table 1- Item, Nickname table 2- Item, Condition, Qua...
Do you have a relationship between Table 1 and Table 2 based on "Item" columns? If so, you can essentially treat them as one big table (more or less)
Yes, I do have a relationship between them. How would I treat them as a table? And would this support the drill down feature?
So for example let's say table 2 now has "Manufacturer" added to it. Could I drill down to Manufacturer, then Nickname/Condition?
Hi Anonymous,
If the tables contain the relation, you can directly drag the columns which you need to a table visual to display them.
Regards,
Xiaoxin Sheng
I'll keep trying to play around with this until I get it to work.