Effectively running a sales team requires decision making based both on fact and instinct. Sales pipeline and weighted sales pipeline value are often used to gauge the “Health” of a sales person’s pipeline and used as an indicator of how likely that sales person is to meet or exceed their sales goal.
The un-adjusted revenue and expected revenue by Practice Area by Sales Rep can easily be represented by the following pivot table: