I have a worksheet that is displaying the top ten projects by total $ amount in a text table. In addition, I have created a column called In-Year LE that is showing a green, yellow or red square based on the status of the project. I want to show the total $ amount of the projects that are being displayed and not the total of all the projects from my data source which is what I get when I add grand totals to column. Does anyone have a solution for this?
3 answers
If you just need grand totals I have another thread solved on this but I am away from computer but would send u asap
