Exercise $2$

There are some groups that had Expenses in $2008,$ but they didn't have any Revenue in $2008.$ We don$$t want those groups included.

Create a new column entitled "Groups with $2008$ Revenue."$$ Do a vlookup to the "Groups$2008"$ tab, which may be hidden.$$ Look up the Group Name and return the Group Name.

Then make a pivot table showing Physician Expense by Group Segment.$$ Filter out the groups with no revenue.$$ Do not remove groups individually.$$ Think of a way to remove them all at once from the pivot table.

Keep pivot table in this tab.