CODEWITHSUNDEEP
excelpivot-table
Ricardo Milhomem
Ricardo Milhomem

Reputation: 169

Excel pivot table relative information

Is there anyway to show information without calculating anything in a pivot table in excel?

For example, I've got a pivot table with a number of invoices and it shows which products are billed in the invoices. I only want it to show the invoice date to the right of the invoice number, without summing it nor counting it or anything, I only want the information to be shown. The invoice date is in another column in the base sheet, by the way.

Thanks!

Upvotes: 0

Views: 160

Answers (1)

teylyn
teylyn

Reputation: 35915

Select a cell in the Pivot Table, then on the Pivot Tools Design ribbon select Report Layout > Show in Tabular Form.

In Excel 2010 the Compact Form was introduced for pivot tables and all pivot tables default to Compact Form, where the row fields are indented and appear in the same column.

The screenshot shows the difference between compact form on the left and tabular form on the right.

enter image description here

Many people don't like the default compact form. If you would like to see this behavior changed, please place a vote in the suggestion at Excel Uservoice here: https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/10535790-allow-users-to-set-choose-defaults-via-settings

Upvotes: 1

Related Questions