Is it possible to create one table in Google Data Studio that shows the campaign name & advertising cost of each campaign and the total cost of all the channels?
Yes, you can do this using the data blending feature in Data Studio. It requires some configuration, but we do discuss how to do this inside our Data Studio Mastery Course.