Microsoft Office Tutorials and References
In Depth Information
Drag and drop Category to the axis Fields section of the configuration window.
From the iNSert ribbon menu, click on the Slicer button and choose Category from the list.
then move the slicer below the pivottable.
right-click on slicer, choose report Connections, and ensure Chart1 and pivottable1 are
rename the sheet to an appropriate name, and save the file.
You can save the file by using the Save & Send option from the Backstage and saving it
directly to the Sharepoint library (powerpivot library), or you can first save the file manually
to the file system and later upload it to Sharepoint powerpivot library.
Your final excel workbook with the powerpivot data will look like the one in Figure 5-54 .
Figure 5-54. PowerPivot window after setting up the data source
in the Connections section of the Data tab, click on properties. in the Connection properties
window, select the Definition tab and click on the authentication Settings button. Select SSS – SSS
iD, and provide the SSS application iD you set earlier to connect to the SSaS database. Click OK as
needed to close all the open windows. Finally, save the excel sheet to your local disk.
Search JabSto ::