Percentage in Crosstab

[sschmelz]

Hi,

I have got a crosstab of the following form:

   #Result      Passed  Failed  Blocked   SUM
Testplan 1       5           10                    15
Testplan 2       4             9          1        15
..
Testplan x       2             3          3          8

for the y-axis I use a data item [Testplan], for the x-axis a data item [Verdict], I am counting on [Result-ID].

How can I add a column "Percent Passed", which contains the percentage of "Passed" executions per Testplan?

[sschmelz]

Hmm, nobody any idea?

My intended result would be like:

  #result.   Passed.    Failed.   Blocked.  SUM.  %passed
Testplan 1.    5.          10.                       15.      33
Testplan 2.    4.           9.           1.          15.      27
....
Testplan x.    2            3.           3.            8.     25

[adik]

%passed query item would be something like: [sum]/total([sum] for report)*100

[sschmelz]

Thank you... well I know how to get a percentage. I am struggling with the exclusive count for "Passed" within [Verdict] to be used in that calculation?
Any idea for that?