Dynamic tables, also called pivot tables, are a tool for database analysis (BD). They are responsible for summarizing and ordering the information contained in the database.
They allow analyzing only a portion of the BD, that is, with a BD with a large number of fields or columns, they help to visualize only the relevant information, with which the analysis becomes easier.
Dynamic tables are based on two concepts: summarization and rotation: Summarization
Refers to the ability to summarize data of the same type and with the same attributes. Summarization is that name that helps us identify a dynamic table of two or more columns and three rows where there are conjugations of cells. Rotation
It is the possibility to place, remove and move any number of fields in any position that is required, as long as these fields are contained in the database.
wiki
