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:
- Values go across the columns initially.
Drag this virtual field to the Row Labels and you will get a different look to the report.
- You can drag Values to the row area.