I have a dataset for each record it has a CompanyID, RevenueMonth, RevenueYear, Revenue
When I create the report, I am grouping each CompanyID and showing their monthly revenue for a given year.
But in a given year, not all companies have any revenues for a particular month.
A sample record would look like:
CompanyID, RevenueMonth, RevenueYear, Revenue
End Result, I would like my report to look like this with CompanyID 1.
In my current Report, it will only fill column headings with March (03), May (05) and August (08).
How do I get my Report to add the missing months for the year?
I hope my questions is clear. This is my first post.