Reply
Regular Visitor
Posts: 37
Registered: ‎10-11-2016

Summed values from different tables?

[ Edited ]

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, 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.

Super User
Posts: 8,974
Registered: ‎07-11-2015

Re: Summed values from different tables?

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!


Regular Visitor
Posts: 37
Registered: ‎10-11-2016

Re: Summed values from different tables?

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?

Community Support Team
Posts: 6,568
Registered: ‎08-14-2016

Re: Summed values from different tables?

Hi @bhanson41,

 

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

Highlighted
Regular Visitor
Posts: 37
Registered: ‎10-11-2016

Re: Summed values from different tables?

[ Edited ]

I'll keep trying to play around with this until I get it to work.