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
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