Forum Discussion
Matrix table with 2 row total columns
Ultimately I having trouble getting a matrix visualization with 2 row total columns. 1 that is the sum total and the other that is the % of the total.
I have a data set of jobs completed by various subcontractors and the week that it was completed. I want to be able to show the # of jobs completed in a given week by each subcontractor with a total count of the jobs as well as a % of the total for each subcontractor. This is what I'm hoping to get as a final result.
I understand that I can create a measure for the % of total but when I include it in the values section, the %s will show for each week as well as a total. I'm just looking for the % on the total.
The other caveat is that this visulaization will have a slicer so that the user can choose what weeks they would like to view.
Any help would be greatly appreciated. Thank you in advance.
Hi kkassel ,
Matrix doesn't support this style at the moment, but you can hide it by dragging it manually, and you can check the result as follows:
An attachment for your reference. Hope it helps!
Best regards,
Community Support Team_ Scott ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi kkassel ,
Matrix doesn't support this style at the moment, but you can hide it by dragging it manually, and you can check the result as follows:
An attachment for your reference. Hope it helps!
Best regards,
Community Support Team_ Scott ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.