Excel Report - A Pivot Table Review

  • The fact is that every user who may have learned to make use of PTs have observed a tremendous rise in their productivity. Not merely due to the speed of developing reports but through the quick insights you can find from large data sets.


    Should you present an investigation of Sales by Product and by Region and someone inquire, what if... You'll say permit me to open the file and drag-and-drop it right this moment.

    Allow me to share the pros of why you need to use Pivot Tables
    - Summarizes 1000s of rows within seconds.
    - Changes the layout of report by just dragging and dropping.
    - Formats your report quickly.
    - Slices and dices your flat table by any category.
    - Permits you to add calculated columns.
    - No formulas needed (a minimum of you employ calculated fields).
    - Does not consume enough memory resources.
    - Formats data ready to be analyzed.
    - Lets you connect to external databases: OLAP, SQL server, Access, etc.

    Listed below are the cons of why you ought to not use Pivot Tables
    - Does not enable you to understand the source of values reported as with formulas (by pressing F2). Anyone desires to see where the data came from to allow them to easily check the formula.
    - Will not offer flexibility to set up customized reports in cells.
    - Does not refresh the outputs immediately in the event the backend list changes.
    - Clutters the workbook if there are a large number of little Pivot Tables everywhere.
    - Occupies space within the worksheet.
    - Won't offer easiness of moving the final results over the worksheet.
    - Does not let edit calculated fields directly from the cells.
    - Offers limited supported functions in calculated fields.

    Conclusion. I'm a fan of Pivot Tables on the other hand 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 option. However, If your input info is relatively static nevertheless, 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 the using formulas unavoidable.
    For more information about what is a pivot table view this popular net page

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!