Double Values Appearing in the view

[rohitians]

Hello,

I am having a straight table where in I am having Vendor master  here in I am having details of all the vendors,

but vendor code is repeating  how can I avoid this situation...I cannot use suppress null becoz there is condition where in I may miss data so...

I am attaching an excel example.

Thanks and Regards,

Rohit Yadav

[swuehl]

It seems to me that you are using more fields than necessary as dimensions.

Only use as many dimensions as you need to group your data by. If you want to show additional information to a dimension, use an expression.

So, I would suggest that you only use VendorCode as dimension.

Create expressions for VendorName etc.

Does this make sense?

[#3]

Hi,

Probably, the problem is in the model, the relations between tha tables, so we need share us the E/R of the model, the sintax of the expressión. If is possible you share us the app, it would be better.

Regards,

Ricardo