How to swap columns and values in Pivot table like Excel

[kendesai]

I want to change the layout of my QuickSight visual to show Values first, followed by Columns (dates). Currently, it shows Columns (dates) first and then Values. Since my columns contain dates, this would help better display monthly performance metrics for each value.

I know Free-Form visual is often suggested, but it won’t work well for my case due to multiple rows and scrolling alignment needs. Is there a simple way to achieve this layout, similar to how we can easily transpose in Excel?

[Ashok]

@kendesai can you please share example screenshot of how the pivot view should look like ?

[kendesai]

@Ashok Attached is the screenshot from someone but this is exactly how i want as well

[andrepgn]

Hi @kendesai,
do you mean something like this?

Before:

After:

Obviously you can change it manually from the Visuals Fields, but the button you have on the pivot should do the swap trick for you

Let me know if this is what you were looking for!

Andrea