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.
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
