Hi,
I have a field X that contains 1000 values of A, B, C or D.
I can use a count[Field X] to create a table that shows A, B, C, D as columns and it will give me the count of each.
Now I want use the columns A B C and D in new calculations but I cannot reference them.
As an example, I want to find out the percentage of A out of A, B and C (exclude D).
In my sample, I want a calculated field that calculates A / (A+B+C) or 10/(10+20+30) = 0.1666
D]{exclude [Field X] : count(if [Field X]<>"D" then [Field X] end)} [Percentage][Count A]/[Count <>D] Thanks,Shin 9." style="display: block;" />
[Count A]
{exclude [Field X] : count(if [Field X]="A" then [Field X] end)}
[Count <>D]
{exclude [Field X] : count(if [Field X]<>"D" then [Field X] end)}
[Percentage]
[Count A]/[Count <>D]
Thanks,
Shin
9.3 attached.
