Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
In Matrix First Open till the last level. See Screenshot and then in Set Stepped layout - off in Row Header property
Use Matrix table and then work with features like +icon, to get the nearest output
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.
In Matrix First Open till the last level. See Screenshot and then in Set Stepped layout - off in Row Header property
Hi amitchandak,
Thank you for solving my problem and thank you for your immediate response. it is working excellent.
User | Count |
---|---|
102 | |
90 | |
80 | |
71 | |
69 |
User | Count |
---|---|
114 | |
100 | |
97 | |
72 | |
68 |