In Table Get only values that Match a condition

[holguinmora]

Hi to all!!!

I have 2 tables, table 1 contains all the data and table 2 contains part of the data

In a graph table I will like to get only the data contain in table 2.

How can this be done?

[dplr-rn]

there are multiple options difficult to recommend best one without having access to a sample.
but an approach you could consider (with minimal information) - you could create a column common to both tables e.g. TableType
and in graphs where you want only table 2
use set analysis e.g. sum({<TableType={'Table2'}>} SAles)

share sample data for what will be in table 1 and table 2 to give a proper recommendation