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][/IMG]
This produces a pivot table which shows data like this in a vertical list.
[/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
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.

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

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