In Spotfire, which aggregation function would you use to calculate the percentage that each row's value contributes to the total for its category?
-
A
Sum([Value]) / Sum([Value]) OVER ([Category])
-
B
Avg([Value]) OVER ([Category])
-
C
Percentage([Value])
-
D
Ratio([Value],[Category])