How to transpose the dataset in quicksight?

I want to make a visual where I can see one brand vs other brand data weekly. I have the dataset imported as shown in the left table. I figured, I might have to transpose the data to satisfy my use case. Can anyone tell how to do it? Thank you.

Hi,

Simple, if there are only two production you case the product filter for both tables only.
Create a one table on dataset, apply product filter. Make copy of it and set filter for the both the tables.
Filter will help you.

regards,
Naveed Ali

Hey Naveed, Thank you for your answer.

Do you have any documentation/links you can share on how to do the above steps?

Hi,

It’s very simple step one. create table with your required column. secondly, apply filter production filter on it.
finally copy the table visual and select the product of the both visual
as you required.

regards
Naveed ali