Pivot Table Limitations - Amazon QuickSight

Pivot Table Limitations

The following limitations apply to pivot tables:

  • You can create pivot tables with up to 500,000 records.

  • You can add up to 20 fields as rows and 20 fields as columns.

  • You can create pivot table calculations only on nonaggregated values. For example, if you create a calculated field that is a sum of a measure, you can't also add a pivot table calculation to it.

  • If you are sorting by a custom metric, you can't add a table calculation until you remove the custom metric sort.

  • If you are using a table calculation and then add a custom metric, you can't sort by the custom metric.

  • Totals and subtotals are blank for table calculations on metrics aggregated by distinct count.