Forum Discussion

danielco's avatar
danielco
Regular Visitor
8 years ago

Filter like in Pivot

hi guys,   After a few hours of research i need to ask this as i can't seem to find it   i have two excels  first with a campaign name website and some target indicators   second has many camp...
danielco's avatar
danielco
Regular Visitor
8 years ago

thanks a lot for your time

 

I'll take a look

 

Just to give you some background:

the  6539_Untitled file usually contains a few thousand lines. With many campaigns, each website can appear in as many campaigns as possible. and i have 2 more files like this.

 

I want to use Sheet 1 table to extract all data related to 1 campaign in all tables available.

 

I need to be able to change what is in Sheet 1 (campaign name) at any point and therefore get reports for as many campaigns as needed

 

Thanks again

IanSwanepoel's avatar
IanSwanepoel
Helper I
8 years ago

Then my reccomendation would be to concatinate the Website and Campaign field to create a key, seeing as it is based on both.
Then using that value to establish the relationship.