I have a large table of transaction data that I am trying to analyze. The table is formatted with a transaction having multiple rows depending on the number of items purchased (one row for each item).

I am using Google Data Studio to visualize my data, but can't figure out how to make a count of how many transactions contain a combination of two products. I can count how many of product A are purchased and how many of product B, but not how many transactions purchase both A&B.

I've tried multiple if statements, but keep facing boolean vs text issues. I've also tried case functions but can't seem to get one that works. How can I build a formula for a custom field that lets me count this?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.