Excel for Data Analysis and Visualization

Laying out the Pivot Report in completely separate columns

You don’t have access to this lesson

Please purchase this course, or sign in if you’re already enrolled, to access the course content.

When starting a Pivot Table, the default is in something called the Compact Format. This is where the rows you include are all in a single column with just a slight indent. We prefer that all our reports have the fields in their own columns. You can achieve this by changing the report layout.

This lesson covers the options with regards to laying out the Pivot Report in completely separate columns or compacting them to fit into a single column.

To see the full course contents click here.

0 of 141 lessons complete (0%)
0
    0
    Your Cart
    Your cart is emptyReturn to Shop