This lesson is about generating multiple Excel reports based on the value of a pivot table's "page" field.

We have several customers who create reports for different branches of a company. Each branch wants a spreadsheet containing only its numbers. This requires a lot of work locating all the data, then dividing it up into individual reports for each branch.

Xcelential makes use of the pivot table's built-in paging feature to do this automatically.

Please make sure you download your Xcelential Professional Free Trial before starting the lessons.

http://www.xcelential.com/DownloadXcelentialPro.html