Hi!
When you click the data points that are summed by a pivot table it produces a new sheet showing all of the data from that sum.
Is there a way to automatically format this on the new sheet?
Ideally what I would like to do is transpose the data to make it easier to view because the data contains many columns.
Any help would be greatly appreciated!
When you click the data points that are summed by a pivot table it produces a new sheet showing all of the data from that sum.
Is there a way to automatically format this on the new sheet?
Ideally what I would like to do is transpose the data to make it easier to view because the data contains many columns.
Any help would be greatly appreciated!
