In the Beast Mode below, End Date 2, Start Date 2, Measure Selection and Client Select are all variables. For the Measure Selection and Client Select, is there an alternative to hardcoding the literal value for each Client Select & Measure Selection permutation? Is there a way to take the variable response and feed it into the beast mode?
SUM(CASE
WHEN Date <= End Date 2 AND Date >= Start Date 2 AND Measure Selection = 'Clicks' AND Client Select = 'Acme' THEN CASE WHEN Benchmark Client Groups LIKE '%Acme%' THEN Clicksend
WHEN Date <= End Date 2 AND Date >= Start Date 2 AND Measure Selection = 'Revenue' AND Client Select = 'Acme' THENCASE WHEN Benchmark Client Groups LIKE '%Acme%' THEN Revenueend
WHEN Date <= End Date 2 AND Date >= Start Date 2 AND Measure Selection = 'Clicks' AND Client Select = 'Beta' THEN CASE WHEN Benchmark Client Groups LIKE '%Beta%' THEN Clicksend
WHEN Date <= End Date 2 AND Date >= Start Date 2 AND Measure Selection = 'Revenue' AND Client Select = 'Beta' THENCASE WHEN Benchmark Client Groups LIKE '%Beta%' THEN Revenueend
ELSE 0
END)
