How to Use One Set of Results to Create Two Pivots

manual-refreshTo create two separate pivots using one set of Results:

1.  Insert a pivot.

2.  Select Pivot on the Tool Bar.

3.  Click on Refresh Data.

4.  Click on Manually.

You can now create as many pivots as you need from the same set of results.  You would change the limits in your results and click on “Refresh Now” to update an individual pivot without changing the information in the other pivots.

Last updated: October 15, 2013

Last updated: October 15, 2013