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.
![Field_List.jpg](/board/proxy.php?image=http%3A%2F%2F%5BURL%3D%22http%3A%2F%2Fpostimg.org%2Fimage%2Fqrx8pq4bv%2F%22%5D%5BIMG%5Dhttp%3A%2F%2Fs1.postimg.org%2Fqrx8pq4bv%2FField_List.jpg&hash=91288481c465c533d13c139074a86de0)
This produces a pivot table which shows data like this in a vertical list.
![Pivot_Table.jpg](/board/proxy.php?image=http%3A%2F%2F%5BURL%3D%22http%3A%2F%2Fpostimg.org%2Fimage%2F7knp0112h%2F%22%5D%5BIMG%5Dhttp%3A%2F%2Fs28.postimg.org%2F7knp0112h%2FPivot_Table.jpg&hash=8959fbdaeded8150d418eada8ec8214b)
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