I’m combining the data from a number of tables in a new table. I’m grouping my view by project each project has some costs I wish to display. I also have staff members that work for a particular project they have costs I also wish to display(yellow). The problem is I see the project costs repeated for each staff member attached to the project(red) I would like to keep the summary. Is there a way to hide them or a different structure to overcome this issue?
Hi @Rose_K ,
Thanks for replying!
I have the summary of Total operational costs and the Total costs which is great, including all the fields that add up to that. It’s more about what I want to hide which is everything in the red area, this is repeated. This is information comes from a table called projects. Per project there are operational costs. Which I need to display. I also need to display the staff linked(linked record) to the project. The issue is that for every staff member added to a project, the project is repeated. Sorry if that’s not super clear.
Looking at your screenshot-- it appears that all the fields you are looking to remove are Lookup fields. You should be able to hide those fields within your view without any of your existing formula fields being affected.
I think that should be the solution to your problem. However, please let me know if I’m not understanding your problem fully!
Gotcha! The summary bar represents the total of the records contained in a field. In its current implementation there isn’t a way to keep the information in the summary bar without the records being present in that field.
You could potentially use the Summary app or another formula field to capture that information in another format though.