Hi all, bit of a newbie here, need your help please!
We have various companies (DNO's) that submit a set of files (A-H) for each month.
I'm trying to generate a combo bar chart which will visually display any missing files.
I have attached an example of what the chart would look like if all files were submitted but I want to see a white section (block) for any file types that are missing for that particular month for a specific company.
The DNO table has the actual files submitted by the companies and the SectionExpected table is just something I tried generating as a table that contains all combinations of Company and Section but not quite sure how to model it or what expressions I need to use to make the chart appear as desired.
Any help much appreciated!!!