For Duplicate Values show only single value

[saikiran]

Hi All,

I have one source file in these file i have some fields those agent and Student ID and Name and Fee. But Agent field i have duplicates i want to show only agent name is onetime but in my data it is repeating already i have created table visual but for agent field i want to show one time Could please any knows the solution please give me reply.Please fine attached photos.

I want Output like this.

This is my Source file

[amitchandak]

Use Matrix table and then work with features like +icon, to get the nearest output

[saikiran]

Hi,

Thanks for your response. If i am using matrix table i am getting output like this.Please find attached screenshot.

But i want ouput Individual for all columns i don't want +icon symbol.if you have any other possibility Please let me know.Please find below attached screen shot for Exact Output.

[amitchandak · Accepted solution]

In Matrix First Open till the last level. See Screenshot and then in Set Stepped layout - off in Row Header property

[saikiran]

Hi amitchandak,

Thank you for solving my problem and thank you for your immediate response. it is working excellent.