Hi,

I created a macro to turn a set of data in to a pivot table. When recording I added data into the columns and values, and then added filters in as well. When I create the Pivot without the macro the filters will stack vertically in the A column above the date. When I used the macro the filters end up going horizontally across the top of the sheet.

Is there a way to create a macro for the pivot table where the filters stack on top of each other?

Thanks!

Rob