Counts for each variable on rows

Hi everyone! I’ve just started using Quicksight so pardon me if the question is trivial.

I have a table made of several columns, each of which represent a variable (let’s call them “var1”, “var2”. etc.). The rows represent my entries which can just be 0 or 1 for each column.

I’d like to create a table that has on the rows the variables and as columns the count of 0s and 1s.
So, for example, I will have a row called “var1” and next to it I have the count of 0s under “var1” and then the count of 1s under “var1”.

How can I do this?

Thanks in advance :slight_smile:

@tancredidorsi QuickSight table visual have feature that allows you transpose rows–>columns and vice-versa.

Let us know if this is resolved. And if it is, please help the community by marking this answer as a “Solution.”