Hi Vivian,

Perspectives allow you to define tables and fields for a particular user group or business scenario, making it easier to navigate large data sets in the Power Pivot window.

You can include any combination of tables, columns, and measures (including KPIs) in a perspective, and you can create multiple perspectives for various reporting groups in your organisation.

The primary use of Perspectives is as a data source for reports and other PivotTables if the workbook is on a SharePoint server. If you don’t have SharePoint then they probably won’t be of use, but I’ll show you another technique later in this video that will apply to everyone.

The example I gave was to set one up for the shipping Department Manager.

I hope that clarifies things.

Mynda

thanks Mynda. it is clear now.

but I’ll show you another technique later in this video that will apply to everyone- what is that technique? 

It's the 'Hide from client tools' technique.