Amazon QuickSight pivot tables now support more data than ever before with new the field limits, unlocking advance use cases. The value field well limits have been increased from 20 to 40, and Rows and Columns have been increased from 20 each to a combined limit of 40. For example, if the user has 34 fields in rows then they can add 40-34 = max 6 fields to the column field well. Refer here for more information.
This is a companion discussion topic for the original entry at https://aws.amazon.com/about-aws/whats-new/2023/01/amazon-quicksight-increased-field-limits-improvements-pivot-table/