I have row subtotals in each matrix and each has a different sources. Is there a way I can make a table to bring each row subtotal into one table?
The row subtotals are added when I make the matrix visual there's an option to turn them on. I would like to move the Row subtotal (ex: APAC) to a new table in another sheet and then eventually add all of them up and make a "global" from each of the rows subtotals that i got from each sheet
Matrix: Last row is the TOTAL that I want to move add to another table