Straight Table repeating values

[#1]

Hi Guys,

I have a straight table, which is repeating values as below. How do I get the straight table without duplicates?

NOTE

• I have used =1 as an expression and have kept it as a hidden expression.
• I do not want to 'Suppress When Value is Null' on that field because Policy Number is an options field
• So if I suppress that field then it will only show me cases where they have policy number but i want to see all the cases.
• I also do not want Pivot table.

About the Data Model

• @ symbol is primary keys which are hidden from users.
• Each OrderID can have more then one Case ID
• Each OrderID can only have none of max 1 Policy Number

Thank you.

[#2]

Thanks Agnivesh, I will try your expression in the actual application as this is just a test data and I will update here soon.

[agni_gold]

ok

[#4 · Accepted solution]

Hi Guys I found the issue and fixed it.

The problem was in the data source.

Thank you all for your time and feedback.