Many to Many relationship

[markgraham123]

Hi,

I have the below data.

When i try to get data in table like,

W2  SUm(Qty)

i get error data when i drill down to SKU....It doesn't show individual SUm() but shows Total() as result in every field...

Can anyone help me

SKU     W1    Qty

1          a          234

2          b          4323

1          c          32

2          d          12

SKU         W2          Location

1          a                    22

2              b          324

1          c          4545

2          d          231

[Kushal_Chawda]

Total number of rows means "Number of rows in your table in which you have created key"

for example

Tab1:

load * inline [

Field

1,

2 ];

Here number of rows =2 and also Count(Field)=2 i.e Field is Primary key

Hope it is clear now