<Li> In addition to Microsoft Excel, competing software programs such as Apache OpenOffice Calc provide similar functionality; the implementation in Apache OpenOffice and LibreOffice up to release 3.3 is called DataPilot . In version 3.4 of both LibreOffice and OpenOffice, DataPilot is renamed "Pivot Table". </Li> <Li> Google Docs initially allowed the creation of basic pivot tables via the pivot table gadget from Panorama called Panorama Analytics, but as of 2011 this gadget provided limited functionality and was extremely slow with large data sets . In May 2011, Google announced the roll - out of a natively hosted pivot table feature in the Google spreadsheets editor . </Li> <Dl> <Dt> Database support </Dt> </Dl> <Ul> <Li> PostgreSQL, an object - relational database management system, allows the creation of pivot tables using the tablefunc module . </Li> <Li> MariaDB, a MySQL fork, allows pivot tables using the CONNECT storage engine . </Li> <Li> Microsoft Access supports pivot queries under the name "crosstab" query . </Li> <Li> Oracle database supports the PIVOT operation . </Li> <Li> Some popular databases that do not directly support pivot functionality, such as Microsoft SQL server and SQLite can usually simulate pivot functionality using embedded functions, dynamic SQL, and / or subqueries . The issue with pivoting in such cases is usually that the number of output columns must be known at the time the query starts to execute; for pivoting this is not possible as the number of columns is based on the data itself . Therefore the names must be hard coded or the query to be executed must itself be created dynamically (meaning, prior to each use) based upon the data . </Li> </Ul>

Why we are using pivot table in excel