Matrix Table with multiple layers breakdown
Hello guys, I have a question that is challenging me and I am struggling to find the write way to visualize it in a matrix table. I have a table as below and I want to create a matrix table where It will show me the headers as the first row and then the breakdown will be Project name, WBSE code, contract number however The key question is how would I make the project name row shows the key numbers and then the wbse row shows only the values set to it without repeating the values above and similarily the contract number values while wbse and contract values will sum to the initial project name row values. Is that possible? Project Name XYZ Location ERP Number Money Allocated Money Spent Money Saved Actuals Total Budget New Total New Budget Department 2 Contract price Project 1 Calgary ZH-000123 $ 50,000 $ 750,000 $ 25,000 $ 5,000 $ 830,000 $ 792,500 $ 150,000 $ 280,000 $ 10,000 Pro - 1 - WBSE $ 25,000 $ - $ 25,000 $ 5,000 $ 55,000 $ 42,500 $ 25,000 $ 30,000 $ 10,000 Contract 1 $ - Contract 2 $ 10,000 Pro 2 - WBSE 2 $ 25,000 $ 750,000 $ - $ - $ 775,000 $ 750,000 $ 125,000 $ 250,000 $ - Contract 3 $ -
