Reporting Question: Calculated field taking in two different fields for one response (nested IF statements, plus an additional value field)
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 C
Value 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 Campaign
GLOBAL Product
All A
All B
All C
How do I write out an "and" statement to pull two different values for one result within my nested IF statements?