⟩ In my report contain Product name, Amount, Country, Sales person. I want to create one prompt Sales Territory.( Ex asia, US, UK, AUS), but territory column is not there in my model and source. if u select the Asia in prompt page-ll Asian country results I want in report page. I discussed with my friends and colleague, they told use the static choice function. Still I face this problem. if u know please tell me?
Based on country column find out the territory.create territory column in model level. In my expectation we should hard code using case condition.
If u find any best answers please give me solution.
