Use Multiple Value Fields as a Column or Row Field
November 28, 2022 - by Bill Jelen
![Use Multiple Value Fields as a Column or Row Field Use Multiple Value Fields as a Column or Row Field](/img/excel-tips/2022/11/use-multiple-value-fields-as-a-column-or-row-field.jpg)
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.](/img/content/2022/11/LE10000802.jpg)
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.](/img/content/2022/11/LE10000803.jpg)
This article is an excerpt from Power Excel With MrExcel
Title photo by Eric Prouzet on Unsplash