Programmatically set column headers for Pivot Tables

Is there a way to programmatically (we are using serverless/yml to build our dashboards) to set column headers in a pivot table? All the solutions I see are going through the console which we are really trying to avoid.

Hey @willk , welcome to the Quicksight Community!

Below I believe I found what you are looking todo with Cloud formation using YAML:

Let me know if this works!

Yep that was it, thank you! For anyone else looking at this the structure goes:
PivotTableVisual → ChartConfiguration → FieldOptions → SelectedFieldOptions

1 Like