Data Studio
4.8K members online now
4.8K 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)