11-17-2016 05:56 AM - edited 11-17-2016 06:14 AM
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, Quantity
What I want is to show Nickname and Condition by Quantity. I'm not sure how to get to this point in Desktop. If I had Nickname in table 2 I could do it by dragging and dropping, but that isn't the case.
Any help would be appreciated.
Edit: This would be a drill-down column. I don't know if that makes a difference.
11-17-2016 09:14 AM
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)
Did I answer your question? Mark my post as a solution!
Proud to be a Datanaut!
11-17-2016 09:55 AM
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?