Saving yourself some time with pivot tables.
If you have been creating all your pivot tables from scratch each time - this trick will save you some time.
Suppose you have created a pivot table showing your Top 10 Products and you also want to create a Bottom 10. No point in starting all over - just copy it.Look at all the time that saves plus you have the same formatting. This is particularly useful if you are setting up a dashboard.
2. Copy the pivot table and place it beside the original pivot table
3. Right-click on an item (or product in this example) in the pivot table
4. Select Filter
5. Select Top 10…
6. Click the drop-down arrow beside Top and select Bottom
7. Click OK
8. Replace Top Products with Bottom 10 Products by typing over it.
How easy was that?
Have a Wonderful Easter.