Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi friends,
I have a input and showing those in table visual, but its coming like this
Name | Subject | Percentage | Result |
Satish | Maths | 75 | pass |
Satish | English | 60 | pass |
Satish | Science | 60 | pass |
Arun | Maths | 45 | pass |
Arun | English | 50 | pass |
Arun | Science | 30 | Fail |
Ella | Maths | 45 | pass |
Ella | English | 50 | pass |
Ella | Science | 30 | Fail |
But I want the result to show like this.
Name | Subject | Percentage | Result |
Satish | Maths | 75 | pass |
English | 60 | pass | |
Science | 60 | pass | |
Arun | Maths | 45 | pass |
English | 50 | pass | |
Science | 30 | Fail | |
Ella | Maths | 45 | pass |
English | 50 | pass | |
Science | 30 | Fail |
Please let me know how to achieve that.
Thanks in advance.
Solved! Go to Solution.
Hi,
To achieve the result, you need to use a Matrix Visual, and not a Table Visual. Add Name and Subject to rows; Percentage and Result to Values.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi,
To achieve the result, you need to use a Matrix Visual, and not a Table Visual. Add Name and Subject to rows; Percentage and Result to Values.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
User | Count |
---|---|
98 | |
90 | |
78 | |
71 | |
64 |
User | Count |
---|---|
112 | |
96 | |
95 | |
67 | |
65 |