We have a request to produce one report that shows the following items:
Global Campaigns, Global Products, Region A, Region B, Region C Value 1
= Region field with a dropdown of Global, Region A, Region B, Region
CValue 2 = Prioritization field that shows what the category they fall
under. So the desired end result for the calculated field would be:
IF(Region="Global" AND Prioritization="Campaign","Global
Campaign",IF(Region = A, "All A","")) Desired result would look like
this:GLOBAL CampaignGL...