Hi,
I use pivot tables often and have various layouts for the tables I review.
For a simple example table 1 is:
Months for the rows with cost and orders for the columns.
Table 2 might is:
Keywords for rows and impressions and clicks for columns.
What I am interested in knowing is there a way to have one pivot table, then have a button, menu, listing the different table formats. I want to be able to choose "table 1" or "table 2" and have the columns/rows change to match the appropriate table?
Thanks.
Bookmarks