Perspectives in PowerPivot without SharePoint & Excel Services

TerryHogarth21

Board Regular
Joined
Mar 20, 2012
Messages
245
Hey All

I like the idea of the perspective in Power Pivot to get a different view of the data.
However, I have not gotten to try this at all since you need Excel Services from what I'm told.

Is there anything else that people do in order to get views in the workbook?

You know what would be great in the Power Pivot, you set up the perspective and then you can filter on that perspective in the Pivot table interface in the front end of Excel.

What are other people doing to get these views without SharePoint/Excel Services?

Put the Pivot Table on multiple worksheets and then pre-set the data?
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

Forum statistics

Threads
1,224,118
Messages
6,176,485
Members
452,730
Latest member
palsmith

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top