Thank you for your response. I ended up changing the data source to mirror a CrossTable output:
Fields: Email Name Subject Sent Opened PromoCode
Data: Email1 Subject1 100 100 abc123
Email1 Subject1 100 100 xyz456
Email2 Subject2 200 50 xyz456
Email2 Subject2 200 50 def000
Email2 Subject2 200 50 hij111
However, I'm wanting to use "Sent" and "Open" fields as measures. Using the format above for the "Count" function is giving me 800 "Sent" and 350 "Opened", when the numbers should be 300 "Sent" and 150 "Opened". I can use the "distinct" to only count unique numbers in these fields, but I'm certain future emails will have the same "Sent" and "Opened" numbers. Is there an expression that will count "Sent" and "Opened" by another field distinctly, such as "Email Name"?
Thank you for your time!
Could I not use the Email Name as the unique key? I only want to count Sends/Opens once for each email.
My thinking is along these lines: For each distinct Email Name, record Sends and Opens once. If the line item below has the same Email Name, do not count Sends and Opens. Continue this until reaching the next unique Email Name, then record Sends and Opens. And so on...
Can I use a combination of Sum and Distinct to achieve this?
Thank you again for your assistance!