AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Data Studio
4.3K members online now
4.3K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Calculated Field: CASE for the sum total number of transactions for a few specific product SKUs

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I have a couple of product SKUs (one is a base, the other base+accessory), that have a software subscription service on top of revenue from the hardware. I want to create a couple of calculated fields.

 

1. The total # of transactions of these specific products SKUs only

2. (The total # of transactions of these specific products SKUs only) * (LTV)