 It is used for interactive table layout and dynamic data analysis.Pivot table has support for an unlimited number of fields.Previously Pivot Table only supported up to 8 column/row/data fields and up to 10 page fields.