You can edit data source, mark these column, right button and select Pivot, so your data will look like this:
Pivot Field Names Pivot Field Values Number of Records Col2 1 Col3 1 Col3 1 Col3 1 Col1 BR 1 Col1 BR 1 Col2 BR 1 Col3 BR 1 Col3 BR 1 Col2 ER 1 Col1 MR 1 Col2 MR 1 Col1 RM 1 Col1 RM 1 Col2 RM 1
And you can easily put Field Names on column shelve, Field Values on Row Shelve, and show number of records. See Attachment
Book1.twbx 12.4 KB
Thank you. I had been struggling, but it turned out to be really easy!