Pivot Table - Moving Values from Columns to Rows

[charlatain]

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]

Thanks,
charlatain

[June7]

Can't do that with pivoted table or form.

Sounds like you should do a GROUP BY (Totals) aggregate query instead of the pivot. Or build a report using Grouping & Sorting with aggregate calcs in header/footer sections.

Be aware, MS has removed pivot table/chart functionality from Access 2013.

[charlatain]

Thank you for this information.

I still want the functionality of a pivot table (i.e. filtering), so I'll pass on the aggregate querying (the source data itself was already produced from aggregation). I will research the "Grouping & Sorting" option though, thanks!

[June7]

Filtering can be applied in aggregate query. Grouping report will have same issue for filtering.