Report design question
In the attached screen shot you will see one of our report by Project and by Time. This module is dimensioned by Time, Project List, Function list and Funding type. We have data for actual, forecast and etc.
We need to see Project ID and Project Status information on this report. But if I add them as line item, they show up under every month. I tried hard coding the module view but people can select the month or year on the report.
Project ID is a property in the Project list. So I'm not sure if there's a good way to display that in this situation? Any insight would be helpful. Thanks.