Showing Columns as row with count of the value

Format the table so that the column titles are presented as raw, underlined text, with each column displaying counts as values beneath the headers.

Source data is Google sheet and the data structure can't be modified in Sheet, so whatever changes need to be applied that will be in Looker Studio. The data is in the first picture, the Large dataset.

I tried the Calculated field but the column name doesn't appear properly, I built the Calculated field for Yes No Partial N/A count, and that works fine.

 

isratJ_0-1738573219300.pngisratJ_1-1738573325464.pngisratJ_2-1738573361961.pngisratJ_3-1738573397522.pngisratJ_4-1738573439906.png

 

0 0 15