DeptID Department Actual Forecast Variance
100 Corporate $187,274 $175,000 -7.01%
101 Accounting $61,456 $60,000 -2.43%
102 HR $88,133 $90,000 2.07%
200 Operations $167,209 $150,000 -11.47%
202 Research $116,801 $125,000 6.56%
206 Manufacturing $175,202 $165,000 -6.18%
301 Sales $169,975 $125,000 -35.98%
305 Marketing $212,012 $185,000 -14.60%
400 Logistics $172,371 $200,000 13.81%
410 IT $92,749 $100,000 7.25%
420 Warehouse $57,845 $75,000 22.87%
Highlight all variances greater than 2% with Green Fill with Dark Green Text
Highlight all variances less than -2% with red Light Red Fill with Dark Red Text
Need to see the databars/ icon sets/custom formatting
DataBars Icon Sets
Employee_ID Post Target sales Achieved sales Dev
E001 Sales 400,000.00 379,000.00 -5%
E002 Finance 400,000.00 200,000.00 -50%
E003 Finance 400,000.00 522,455.00 31%
E004 Finance 400,000.00 500,000.00 25%
E005 Marketing 400,000.00 221,453.00 -45%
E006 Marketing 400,000.00 114,526.00 -71%
E007 Sales 400,000.00 772,524.00 93%
E008 Marketing 400,000.00 566,656.00 42%
E009 Marketing 400,000.00 253,363.00 -37%
E0010 Sales 400,000.00 452,631.00 13%
E0011 Sales 400,000.00 455,226.00 14%
E0012 production 400,000.00 236,652.00 -41%
Highlight entire row for Duplicate values
Employee_ID Post Target sales Achieved sales
E001 Sales 400,000.00 379,000.00 2
E002 Finance 400,000.00 200,000.00 1
E003 Finance 400,000.00 522,455.00 1
E004 Finance 400,000.00 500,000.00 2
E005 Marketing 400,000.00 221,453.00 1
E006 Marketing 400,000.00 114,526.00 1
E007 Sales 400,000.00 772,524.00 1
E008 Marketing 400,000.00 566,656.00 2
E009 Marketing 400,000.00 253,363.00 1
E0010 Sales 400,000.00 452,631.00 1
E0011 Sales 400,000.00 455,226.00 1
E0012 production 400,000.00 236,652.00 1
E004 Finance 400,000.00 500,000.00 2
E008 Marketing 400,000.00 566,656.00 2
E001 Sales 400,000.00 379,000.00 2
Custom Formatting
Difference Custom Formatting
-21000.00 21000.00▼
-200000.00 200000.00▼
122455.00 122455.00▲
100000.00 100000.00▲
-178547.00 178547.00▼
-285474.00 285474.00▼
372524.00 372524.00▲
166656.00 166656.00▲
-146637.00 146637.00▼
52631.00 52631.00▲
55226.00 55226.00▲
-163348.00 163348.00▼
Custom Formatting Rules
Positive in Green with Up pointing triangle symbol
Negatives in Red with down pointing triangle symbol
Values with two decimal places
Country Salesperson Product Name Quantity
Germany Janet Leverling Aniseed Syrup 6
Mexico Janet Leverling Camembert Pierrot 10
Mexico Janet Leverling Chang 20
US Janet Leverling Chartreuse verte 21
France Janet Leverling Chocolade 15
Germany Janet Leverling Escargots de Bourgogne 40
France Janet Leverling Fløtemysost 20
US Janet Leverling Grandma's Boysenberry Spread 16
Finland Margaret Peacock Gudbrandsdalsost 1
Mexico Margaret Peacock Ipoh Coffee 15
Mexico Margaret Peacock Konbu 10
France Margaret Peacock Lakkalikööri 15
Germany Margaret Peacock Mascarpone Fabioli 10
France Margaret Peacock Mozzarella di Giovanni 10
Germany Margaret Peacock Original Frankfurter grüne Soße 2
Mexico Michael Suyama Outback Lager 5
Mexico Michael Suyama Queso Cabrales 2
Germany Michael Suyama Raclette Courdavault 15
Germany Nancy Davolio Rössle Sauerkraut 2
Germany Nancy Davolio Rössle Sauerkraut 15
Mexico Nancy Davolio Singaporean Hokkien Fried Mee 5
Germany Nancy Davolio Singaporean Hokkien Fried Mee 20
Germany Robert King Spegesild 2
France Robert King Teatime Chocolate Biscuits 7
France Robert King Tofu 3
Germany Robert King Vegie-spread 20
Highlight Entire row once the country & salesperson is se
Formatting should be dynamic
Extended Price Country Salesperson
$60.00 Germany Margaret Peacock
$340.00
$380.00
$378.00
$191.25 0
$530.00
$430.00
$400.00
$28.80
$690.00
$60.00
$270.00
$320.00
$348.00
$26.00
$60.00
$42.00
$825.00
$91.20
$684.00
$70.00
$280.00
$24.00
$64.40
$69.75
$878.00
country & salesperson is selected from the drop down list.
