How to transpose columns in a calculated table

Hi all

I m trying to create a pie chart with 3 columns (CC alone, IA alone and IA and CC )and it is not displaying the data correctly. Could it be because my data is spread across multiple column?

So i was trying to transpose multiple columns (CC alone and IA alone and IA and CC) but because this data is in a calculated table whenever i open the query editor it return me back to the actual table.

How can i solve this problem? Also how can you create relationship between your actual table and a calculated table or is it not needed?