Holy crud! That's it exactly!
I hate to bug you further, but I've never messed with Parameter Controls. Would you mind walking me through the process of what you did?
1 of 1 people found this helpful
Hi, I think this is the process:
Remove the measure values you have:
SUM($$) and SUM(Value)
Created Parameter: (Check Toggle Control under Parameters)
Data Type: Float
Allowable values: Select List
Value Display As
// Show parameter control
Create a calculated field so Parameter will work: (Check Toggle under Measures)
If [Toggle Control] = 1 Then Sum([$$]) else Sum(Value) END
// If you choose $$ in the parameter control, it will give you SUM($$)
If you choose Value, then SUM(Value)