Convert table to graph with hidden rows

I need to make a bar chart and a line chart of the number of primary school students with +15% absence for each school. In order for me to do this I need to count  how many students (social security number) who has over 15% absence. When I've done that I use a calculation to count the number of students (sum(0,all(c),m3)). Since I have to make a graphic presentation the social security numbers have to be hidden, which I simply do in visibilities. This works fine when I create a table (yellow marks where I hide social security numbers)

But if I choose a bar chart or line chart I get an error which says there is not enough data.

I don't quit understand why Targit can handle to hide the social security numbers when it is a table and not a chart. For me the table and the table behind chart look identical.

Does somebody have any good suggestions on how to make the above table to work in a bar chart or line chart? I can read that someone had a similar question and the suggestion was to switch rows to columns (https://community.targit.com/hc/en-us/community/posts/360015702358-Diagram-visualization-of-column-total-of-row-wise-calculation-with-time-dimension?input_string=Convert%20table%20to%20graph%20with%20hidden%20rows), that unfortunatly won't work in my case.