I assume I need to use calculated dimensions but I couldn't get it to work properly (i.e. show anything). Also, not sure how I can define in a calculated dimension to only group certain fields and keep the rest as is.
For example, I'd like to group:
'PPC Google', 'PPC Bing', 'PPC Other' to just 'PPC'