Cross Tab KPI?

[codrutza]

CRXI

Please help me with this:

I have to do basically a cross tab:
Columns: Departure Location
Rows: Arrival Location
Summarized Fields:
I have to summarize sum(@Days Dep Arr) / sum(nr of jobs)
Where @Days Dep Arr is a formula that count nr. of days between departure date and arrival date, which I wrote, but the problem is how can I put in the cross tab at Summarized Fields sum(@Days Dep Arr) / sum(nr of jobs)?

Is this possible?

 

[codrutza]

sorry sum(@Days Dep Arr) / distinctcount(nr of jobs)

 

[codrutza]

I have now in the cross tab:
a b c
D 200/10 40/5 30/1
E 35/7 20/1 100/5

Where for example 200/10 - sum nr. days/ distinct count jobs from a to D
How could I get the result in cross tab? Is possible?
a b c
D 20 8 30
E 5 20 20