One of the benefits of summarizing data using pivot table’s is that you can refer to a PivotTable cell, including subtotals and grand totals, in your dashboard.
- [Instructor] One of the benefits…of summarizing data using a pivot table…is that you can refer to a pivot table cell,…including subtotals and grand totals,…in your dashboard.…That way you get all the benefits of a pivot table…with the compact data display of a dashboard.…In this movie,…I will show you how to link to a pivot table cell…and also a cool trick…that allows you to display the data that you want…from a pivot table…just by changing the value in one cell.…I will work with the link to pivot workbook.…
And that's a sample file…that you can find in the chapter two folder…of the exercise files archive.…First I'll just create a link to a pivot table cell.…I'll create it in cell B3…which for me is already selected.…If not, please click it now.…Then type in the equals sign.…And then go to the RoomPT worksheet.…I'll click that sheet tab here.…And this is the pivot table that I want to work with.…I'm looking for the grand total…of all room service revenue from the year 2015.…
I'll go to cell F5 and click it.…And that identifies the cell.…
Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Managing data using Excel tables
- Managing PivotTables and PivotCharts
- Summarizing table and PivotTable data
- Defining conditional formats
- Creating sparklines
- Sketching your dashboard layout
- Creating and managing cell links
- Linking cell contents to a shape
- Linking to a PivotTable cell
- Extending your dashboard using hidden rows