Forum Discussion
Merge rows but keep all the data
i think i've fixed it? by using a matrix visual instead. the total row displays the total but inputs a projects name for some reason but its working i believe from the testing i've done - thanks anyway
Morning,
thanks for the reply, this is a basic version of what im trying to show with an example of how the raw data is provided due to the way system works with different "tasks" (i dunno!)
Anyway, i want to merge the data with the Project Number being used as a reference all into one row.
(I'm somewhat self taught so might need babying when trying to explain it to me sorry!)
| Project number | Project Name | YTD Actuals | FYF | Budget | Project Status | Project Sponsor | Category | FYF % Difference vs Budget |
| 123456 | Tech Serv | £477,214 | £601,033 | £209,000 | Funded | Mr Smith | Business Services | 288% |
| 123456 | Tech Serv | £0 | £0 | £209,000 | Funded | Mr Smith | Business Services | -100% |
i think i've fixed it? by using a matrix visual instead. the total row displays the total but inputs a projects name for some reason but its working i believe from the testing i've done - thanks anyway