Cisco Cisco StadiumVision Mobile Streamer Maintenance Manual
© 2011 Cisco Systems, Inc. All rights reserved. This document is Cisco Internal Information.
Page 25 of 28
b. Add “=SUM(K2/60)” to cell R2
c. Duplicate R2 to every R cell until the last cell row of the sheet, 28263
in this example. (CTL+c on R2, click on R3, scroll to 28263, Shift-click
on R28263, then a CTL+v).
on R28263, then a CTL+v).
6. Reset the PivotTable data range to the new sheet:
a. In the example _min_pivot.xlsx window click the desired tab: Total
Plays in Venue, Summarized Play Time, or Content Time Stamps.
b. Select the rows that you want to include in the PivotTable. This
updates the MS Excel tool bar.
c. Select Insert > PivotTable from the tool bar. The Data > PivotTable
toolset displays in the ribbon menu.
Figure 22. PivotTable Tool Set
d.
Click on the Change Source tool in the ribbon. The following dialog
box displays. Note that the information in the dialog box will be
incorrect as it will reference the Example Data Set tab.
box displays. Note that the information in the dialog box will be
incorrect as it will reference the Example Data Set tab.
Figure 23. Change PivotTable Data Source Dialog Box
e. Edit the Location field to point to the location of the data set. Follow
this string format with the tab that contains the data set and the row
value obtained in step 3 being different:
value obtained in step 3 being different: