Forum Discussion
Subtotals for a Matrix
I am trying to create a tool that will estimate the amount of time a part will need to get through every operation on its routing through the factroy. I am using three columns, part number, workcenter, and queue time. For each part number, I need a sum of the queue time values. I am using a matrix for the visualization. I can not provide the actual data, but I will provide a simplified example of my data. Thank you in advance for any help you can provide.
Anonymous It seems you are using all fields under "Rows" section, please use the "Queue Time" under values section.
7 Replies
- PattemManohar
Community Champion
Anonymous Yes, it should work the matrix without any issues. Make sure, you have turned on the "Row Sub Totals" under Matrix visual properties.
PattemManohar I have tried this and can not get the subtotals to show up for my matrix.
- PattemManoharPlease share how your matrix visual looks like, hope you have clicked on the "Expand all down one-level in the hierarchy" on the top of the matrix visual (down arrows that you can see)