Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 keep IKY and Company Code as a main filters in my Visuvalization.
It might be better if you showed your example with some dummy data and a "LOAD * Inline" script. As it stands now, the formatting makes it difficult to see what's you've got, and where you want to go.