Data Model Issue

[abubakarsiddiq7]

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.

[JustinDallas]

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.