Hi all,
I have a pivot-table that calculates from a worksheet called "data" range:A1:E54710.
The left-hand side of the pivot is the contents of column C.
The pivot table calculates the following: count of column D, sum of column E, sum of column F, and sum of column G.
At the moment, the pivot-table has the 4 data items listed vertically for each item. Ideally I would like to report on them horizontally, which would make it much easier to view.
Any ideas on a function or VBA that would help me.
Thanks
Amy xx
Bookmarks