Help with Power Pivot - cannot show values in rows rather than columns

mb2409

New Member
Joined
Sep 22, 2014
Messages
2
Hi,

I'm trying to reproduce a pivot table in Power Pivot to take advantage of the additional tools it offers. However, when creating the pivot table from Power Pivot and adding fields I cannot get the data sit in rows on top of each.

In my existing pivot table I add the field to the values section and it sums the data. I then end up with the Values field sitting in Row Labels.

[URL="http://postimg.org/image/qrx8pq4bv/"][IMG]http://s1.postimg.org/qrx8pq4bv/Field_List.jpg[/URL][/IMG]

This produces a pivot table which shows data like this in a vertical list.

[URL="http://postimg.org/image/7knp0112h/"][IMG]http://s28.postimg.org/7knp0112h/Pivot_Table.jpg[/URL][/IMG]

In Power Pivot I can only get these fields to list as Columns alongside each other.

Any suggestions? Do I need to do something differently with the data in Power Pivot?

Mark
 

Some videos you may like

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
35,503
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
In the PowerPivot field list, drag the Values button from the column area to the Row area.
 

mb2409

New Member
Joined
Sep 22, 2014
Messages
2
In the PowerPivot field list, drag the Values button from the column area to the Row area.

In my power pivot there isn't a Values button. I'm only given the 'Sum of NSV' which when I move across lists each individual value as a row name.

[URL="http://postimg.org/image/6apf1iqc3/"][IMG]http://s29.postimg.org/6apf1iqc3/Power_Pivot_field_list_1.jpg[/URL][/IMG]
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
35,503
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
What if you add another Value field?
 

mozartiano

New Member
Joined
Sep 18, 2014
Messages
18

ADVERTISEMENT

If you are talking about power view, I suggest that you go to the DESIGN menu and locate TABLE, click it and change to MATRIX. It will Display fields like VALUES, COLUMNS, ROWS and FILTER.

Thanks
 

Tianbas

Board Regular
Joined
Apr 29, 2014
Messages
101
That is the one case you need the standard Pivot field list and not the PowerPivot Field list.

Right-click on you pivot table and select "show field list" and you will see the standard field list that has less fields than the PowerPivot filed list but it has a sum for the values that you can move between rows and columns.
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
35,503
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
It must vary between PP versions then, because I have a 'ƩValues' field I can move in the PowerPivot field list in 2010.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,991
Messages
5,526,099
Members
409,685
Latest member
Bellybb

This Week's Hot Topics

Top