Tuesday, December 13, 2005

The power of Pivot Table (Part VII)

Let's have something simple today. Now if you have a pivot table that shows two attributes on the left column of the pivot table, i.e. Customer Name followed by Promotion as per our pivot table we created in PART V. Do you know that you could hide the details such as those under promotion?
  1. What you need to do is to double click on a particular customer name and the promotion details are hidden.
  2. To unhide the details, double click on customer name again and the details under promotion appear.

No comments: