1 of 1 people found this helpful
You can't change your data source data. But you can make a new calc that contains your modified data.
IF [Service Action] = "No Show" THEN [Measure] * .75
IF [Service Action] = "No Show" THEN SUM([Total Amount]) * .75 END
I got a calculation error "Cannot mix aggregate and non-aggregate functions.