You can try to use Cross Load of your data. Like
CrossTable(ShowName, Category, 3) LOAD #, Subject, Description, TVShow1, TVShow2, TVShow3 FROM Source;
Then, Create the Pivot chart, Put your Dimension.
The expression should be Count(Category)
Drag your ShowName and Catagory Field to top of Pivot.
I believe, this is what you need. Let us know, if this not suits
Qvcomm_762486.qvw 154.0 K