Forum Discussion

saikiran's avatar
saikiran
Helper I
6 years ago
Solved

For Duplicate Values show only single value

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

 

Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

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

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

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

    • saikiran's avatar
      saikiran
      Helper I
      6 years ago

      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's avatar
        amitchandak
        Super User
        6 years ago

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