This content has been marked as final. Show 1 reply
I would suggest to use Receive_Count and Send_Count in the prompt instead of single column for both.1 person found this helpful
Since you are asking for 1 column for country, use presentation variable for country and set that in the report
Receive_Count = PS variable or Send_Count= PS variable.
That means report should fecth (for selected date and country from prompt) for that date country is in Receive_Count or Send_Count
Create measures in rpd
case when INDICATOR='SEND' then uniref end and set aggregation to count and do the same for
Or else you can do this in the report pull column uniref twice and for each use filter button from fx and add above condition.
If helps pls mark else send me email