i have 3 tables
T1:
Current Year Sales
Previous Year Sales
Company Name
Selection Code--->Key Field
Sales
PLC
T2:
IKY,
PLC,
"Company Name"
"Total Accounts",
"New Target",
"Sales Target
T3:
IKY ,
PLC,
"Company Name"
Selection Code
"Store Location",
"2019 Target"
combination of PLC + "Company Name"(Key Field) need to join T2 and T3
then Need to Join with Selection Code(Key field) with T1.
Note: i have to see IKY and Company Code as a main filters in my Visuvalization.
