ANSWER AND STEP BY STEP EXPLANATION ON HOW TO SOLVE WITH PICTURES INSTRUCTIONS: Build onto Pivot Table in cell A$3.$

Display the Project Category and Potential Revenue.

Show the winning Bid Amount per Project Category.

Table A

$\backslash$table$[[$Project Category,Bid Amount,Won or Lost,Budget Tier,Potential Revenue,,$],[$MKTG ONLY,$$103\mathrm{.}00,$Won,$$5,000$ to $$10,000,$$$10,800\mathrm{.}00,,],[$MKTG ONLY,$$106\mathrm{.}00,$Won,$$10,000$ to $$15,000,$$$21,600\mathrm{.}00,,],[$WEB ONLY,$$51\mathrm{.}00,$Lost,$$15,000$ to $$20,000,$$$36,764\mathrm{.}00,,],[$MKTG ONLY,$$77\mathrm{.}00,$Lost,Above $$20,000,$$$26,460\mathrm{.}00,,],[$MKTG $+$ WEB,$$80\mathrm{.}00,$Won,$$10,000$ to $$15,000,$$$19,251\mathrm{.}00,,],[$WEB ONLY,$$73\mathrm{.}00,$Lost,$$15,000$ to $$20,000,$$$14,908\mathrm{.}00,,],[$WEB ONLY,Lost,$$15,000$ to $$20,000,$$$14,908\mathrm{.}00,,,],[$MKTG ONLY,$$51\mathrm{.}00,$Won,Below $$5,000,$$$21,600\mathrm{.}00,,],[$MKTG $+$ WEB,$$51\mathrm{.}00,$Won,$$15,000$ to $$20,000,$$$34,375\mathrm{.}00,,],[$MKTG $+$ WEB,$$208\mathrm{.}00,$Lost,$$5,000$ to $$10,000,$$$38,348\mathrm{.}00,,],[$WEB ONLY,$$5,000,$$$16,748\mathrm{.}00$