MrExcel.com - Your One Stop for Excel Tips & Solutions

Use Multiple Value Fields as a Column or Row Field

November 28, 2022 - by

Use Multiple Value Fields as a Column or Row Field

Problem: When I create a table with two or more Values fields, Excel has those fields stretch across the column fields. Is it possible to change to other layouts?

Strategy: Look for a virtual field in the Column Labels drop zone called ∑ Values. This field can be pivoted to another location. It starts out in the column labels:

The Sigma Values tile is in the Column Labels. This forces Sum of Revenue, Sum of COGS, and Sum of Profit stretch across B3:D3.
Figure 835. Values go across the columns initially.

Drag this virtual field to the Row Labels and you will get a different look to the report.

Drag Sigma Values tile from Column Labels to Row Labels. Now Sum of Revenue, Sum of COGS, and Sum of Product is in A5:A7.
Figure 836. You can drag Values to the row area.

This article is an excerpt from Power Excel With MrExcel

Title photo by Eric Prouzet on Unsplash