Pivot Table - Moving Sums from Columns to Rows

[milkman2500]

Hi,

In Excel Pivot Tables I can move my sum/count values from the column to the row. I can't find how to do this in Access Pivot Tables.

To clarify, I currently have:

[Column Header 1] [Column Header 2]
[Sum][Count] [Sum][Count]

But I want:

[Row Header 1]
[Sum]
[Count]
[Row Header 2]
[Sum]
[Count]

 

[JHB]

It can not be like that in MS-Access, then you have to code it in VBA.