Calculated Value Percent of Subtotal

[Hesloan Viana]

I want to create a calculated value in Text Area that show me % of a column with a certain status over all status. How can i do this

Example:

Protocol Value Status

1 22 A

2 12 A

3 87 B

4 78 B

5 35 C

Count([Protocol]) of Status 'A' / Count([Protocol]) of all status, and show this like a percent.

Sum([Value]) of Status 'A' / Sum([Value]) of all status.

[Khushboo Rabadia]

You can use conditional statement in your ifrst clause like

count(case when [status]='A' then 1 end)/count([protocol])

Same applies while summing up the value column.