Showing all possible values in bar chart

[jessica_webb]

I'm hoping someone can take a look at the attached for me.

What I want is to select from the 'Cat & SubCat' list box, and for the chart to show all possible grades for that 'Cat' along the X axis (obviously many of them will be null values).

For example, when I select 'A English', I should see A* - E along X axis, but with values only for 'A' and 'B'

Have tried various JOINS/KEEP functions in script, but still no joy!

I also don't want to bring 'Type C' from the 'Possible' table into the data - so I only want to join the Types that appear in the 'Main' table.

Thanks,
Jess

[Kushal_Chawda]

I don't know but it may cause some issue due to synthetic keys. If it works for you then that's really good. You can mark the appropriate answer as correct or helpful