CASE [Metric name]
WHEN "Spend" THEN Sum([Spend])
WHEN "Sales" THEN Sum([Sales])
WHEN "CostPerSale" THEN SUM([Spend])/SUM([Sales])
I did that then I get the error message for one of graphs:
The calculation 'sum of metric value' can't be applied to a user defined aggregate
Any thoughts for next steps?
can you provide a sample workbook with the issue?