Johannessen Kastrup posted an update 6 months, 1 week ago
The truth is every user who’s learned to use PTs have observed a huge boost in their productivity. Not simply because of the speed of creating reports but from the quick insights you can get from large data sets.
In case you present a written report of Sales by Product and also by Region and someone ask you, what if… You would say allow me to open the file and drag-and-drop it right this moment.
Allow me to share the good qualities of why you need to use Pivot Tables
– Summarizes thousands of rows within minutes.
– Changes layout, design of report through dragging and dropping.
– Formats your report quickly.
– Slices and dices your flat table by category.
– Allows you to add calculated columns.
– No formulas needed (at least you use calculated fields).
– Does not consume enough memory resources.
– Formats data ready to be analyzed.
– Allows you to hook up to external databases: OLAP, SQL server, Access, etc.
Here are the disadvantages of why you should not use Pivot Tables
– Does not allow you to understand the method to obtain values reported as in formulas (by pressing F2). Anyone wants to see where the data originated so they can easily look into the formula.
– Doesn’t offer flexibility to prepare customized reports in cells.
– Will not refresh the outputs immediately once the backend list changes.
– Clutters the workbook in case there are many little Pivot Tables everywhere.
– Occupies space from the worksheet.
– Does not offer easiness of moving the final results through the worksheet.
– Won’t let it edit calculated fields directly in the cells.
– Offers limited supported functions in calculated fields.
Conclusion. I’m a fan of Pivot Tables but I am a fan of Lookup formulas too. Should you be looking for what-ifs calculations by changing the inputs, data Lookup formulas has to be good choice. However, Should your input info is relatively static but you might like to do what-if analysis with drill-down, then Pivot Tables are a good choice. Unfortunately, the limited aggregate functions for sale in a Pivot Table, the impossibility to embed outputs in other formulas along with the limited functions supported within a calculated field make use of formulas unavoidable.
More details about
what is a pivot table go to see this web portal