I need to sort Pivot Table data and post to another worksheet with all the details.
In a pivot table, it only list the catagory once on the first field. When I copy and paste so I can sort on the amount filed, it does not have the details which go with it. I need the reference to follow the amount.
I am new to Pivot Tables and there is probable an easy way to get the details to fill in each cell not just the heading.