Solved

How do I display a pivot table with row headings horizontally across the top ?

Posted on 2013-10-22
2
544 Views
Last Modified: 2013-10-22
Hi Experts,

I am creating a pivot table in which I want to present the row headings as column headings, with the associated data in separate columns like the image I've attached.

However, when I drag the fields into the 'Row Labels' pane of the Pivot Table Field List the data only indents a little, and all in the same column.

I know the fields can be separated out into adjoining columns as I've seen it elsewhere.

Regards
Phil
Pivot-table-screen-shot.PNG
0
Comment
Question by:Tocogroup
2 Comments
 
LVL 21

Accepted Solution

by:
Ejgil Hedegaard earned 500 total points
ID: 39592214
In the table settings, switch to classic layout and switch off column totals.
Then the fields Region, Country and Company will be displayed in separate columns when inserted as row labels.
No of Employees must be a value, otherwise you don't get the sum.

Remove subtotals from each field = set to none.
Then you have a table that is close to what you want.
See attached file.
Pivot-table-headings-at-top.xlsx
0
 

Author Closing Comment

by:Tocogroup
ID: 39592225
That's great. Just what I wanted.

Many thanks
Toco
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
We were having a lot of "Heartbeat Alerts" in our SCOM environment, now "Heartbeat" in a SCOM environment for those of you who might not be familiar with SCOM is a packet of data sent from the agent to the management server on a regular basis, basic…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now