Extend your dashboard using hidden rows

- [Instructor] Dashboards summarize a lot of data…in a compact format.…You should avoid the temptation to display…too many items on a dashboard,…but there will be times when you want…to make certain information easily available,…even if it's not shown all the time.…You can do that by hiding worksheet rows…that contain some of the details displayed in the dashboard…by creating custom groups.…I'll show you how to group and ungroup rows in this movie.…My sample file is HiddenRows,…and you can find it in the chapter two folder…of the exercise files collection.…

The top portion of this dashboard worksheet…contains information such as room service revenue,…guest count, department expenses, and then a pivot chart…indicating quarterly expenses by department.…Starting in row 11, you can see that I have…Target Quarterly Expenses by Department in 2017,…and then I have the targets in rows 12 through 15…for each of my four departments.…The thing is I don't really need to see the targets,…but I'm assuming that the manager who's using this dashboard…