Show only records value in Table as dimension same as expression value

[mahnoor1279]

Hello everyone,

I want to ask that why the records are getting higher than the expression can anyone help me out from this,

I'm using this expression but when i entered the CUST_SNO_T with other details  in the table the records were exceeding from 42135.

[vinieme12]

Your data is most likely n:n related

 n  values of table1 are associated to n values in table 2

refer example below, when you add Dim1 to a table chart, you will see 4 rows instead of 2 rows

table1:
load * inline [
Dim1,Dim2
A,a
A,b
B,a
B,b
];

table2:
load * inline [
Dim2,ID,field1
a,1,2302
b,2,3042
];