Pivot Delivery Summary dynamic report by "Week" + Specific Country | Community
Skip to main content
mbkass
Level 3
September 30, 2020
Solved

Pivot Delivery Summary dynamic report by "Week" + Specific Country

  • September 30, 2020
  • 1 reply
  • 1001 views

I am able to take the delivery summary report that contains any metric of my choice (sends, opens, clicks, etc) and pick a dimension like "week" in order to see all email channel metrics by week over a specific time period (e.g. one year). However, I would like to pick a specific country (e.g. Japan) and see those weekly results, instead of seeing it for all countries. 

 

I could take the country dimension and place it inside each week, but that would end up showing me results for all 200+ countries per week, which is overwhelming. Is there a way to pick a specific country and filter the weekly results?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by bisswang

Yes, you can filter the list:

  • Drag country dimension into the report
  • click on Japan to select the row
  • Then right-click and choose "Display only selected rows"
  • This should now filter the report accordingly

1 reply

bisswangAdobe EmployeeAccepted solution
Adobe Employee
September 30, 2020

Yes, you can filter the list:

  • Drag country dimension into the report
  • click on Japan to select the row
  • Then right-click and choose "Display only selected rows"
  • This should now filter the report accordingly