Ruan McLoughlin
New Member
Hi,
I have a PivotTable with 6 "Row Labels" with no "Column Labels" or "Values". I am just using the PivotTable as a neat way to easily present and list data that I update regularly.
Using the PivotTable Tools>Design>Report Layout tool I am using the "Show in Tabular Form" option. As my first three "Row Labels" have very little information, and don't need a column all of their own, I would like to arrange them under each other, like they appear when I use the "Show in Compact Form" option (all in one Column and no title), while the last three appear in their own columns with titles.
Is it possible to use a combination of both "Report Layout" options??
Thank you,
Ruan
I have a PivotTable with 6 "Row Labels" with no "Column Labels" or "Values". I am just using the PivotTable as a neat way to easily present and list data that I update regularly.
Using the PivotTable Tools>Design>Report Layout tool I am using the "Show in Tabular Form" option. As my first three "Row Labels" have very little information, and don't need a column all of their own, I would like to arrange them under each other, like they appear when I use the "Show in Compact Form" option (all in one Column and no title), while the last three appear in their own columns with titles.
Is it possible to use a combination of both "Report Layout" options??
Thank you,
Ruan