Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Community,
I am wondering if there is any way to not show the sub-category values while keeping the row total in the matrix. For example in the below matrix, is there any way to only show the subcategories (a1, a2, a3, a4), but not showing their values (1, 5, 4, 2)? The desirable format would be like the second picture.
Any help would be greatly appreciated. Thanks in advance!
Solved! Go to Solution.
Hi @Anonymous . You should be able to accomplish that with the ISINSCOPE() function. There's a pretty good code example on the page as well...
Hi @Anonymous . You should be able to accomplish that with the ISINSCOPE() function. There's a pretty good code example on the page as well...
This works! Thank you for the help!
@Anonymous de nada! Glad I could help!
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
111 | |
96 | |
96 | |
67 | |
63 |