Pivot

[jamescooper]

Hello,

Trying to use powerpivot have a table with 14 million rows, then I want to filter this table by using another table with selections that appear in one of the columns in the main data table (14 million row).

Anyone know how to do this? Any links to guides be appreciated.

Many thanks.

 

[SpillerBD]

You need to join the tables so that one becomes the filter for the other.
You can accomplish using the Get and Transform feature.