Pivot Table layout changed in latest QS version

[chabbils]

Hi all,

I’ve created below visualisation using Pivot table one year ago.

Today I’m using a similar dataset but am unable to create same visualisation using Pivot table. This is how the latest visual looks like (i.e. the rows have become columns). I understand that the formatting/layout of Pivot table is changing due to changes in Quicksight features. But I really want to know how can I implement same visualisation (i.e. the one in old dashboard)?

Thanks

[DylanM]

Hello @chabbils, it looks like you just need to alter the pivot options to get the result you are wanting. After testing this a bit locally, I think you want to change the Layout to Tabular and the Values position to Rows. That seemed to make my pivot table show the format similar to your first screenshot. Let me know if that helps!