Cross tab calculation

[SynexusStuart]

Hi, I'm having a problem with a crosstab calculation (please see pdf attachment)

I have created a simple cross tab, in the crosstab columns there is a top level (Lancashire, Manchester etc.) and another, nested crosstab node member on which there is a filter (DNA, Completed).

What I need, is to create a basic calculation which gives me a percentage of DNA/Completed for each location in the same crosstab. When I try and use a "layout calculation" it tells me I can't do that in a crosstab and I can't get my head around the syntax of writing a query calculation for it.

Must I create and aggregate the two values before starting this of can I get straight to it?

I have only been using RS for a month or two so please be gentle with me!

Hope someone can help,

Cheers
Stuart

[DSR]

Hi....

Just Use Query calculation and write your  expression (DNA/Completed)....Drop this after completion column in your cross tab...Then u will get ur result........

It is working fine....

Regards,
Sanjeev