Referencing another row in a table

[c_gilbert]

Please can anyone help, we currently have a straight table with the 'Ward' as the dimension, and results and RAG ratings as the expressions.

For some results, the wards have joint data, but we don't want to duplicate the data at the source, we just want to base the RAG rating of one ward on another ward.

For example, here is a very simple representation of what we have now. At the moment Ward1b is showing red as there is no data, but we want it to show green, as Ward1a is green.

Ward	Result	RAG rating
Ward1a	90%	Green
Ward1b	-	Red

And this is what we want to get to:

Ward	Result	RAG rating
Ward1a	90%	Green
Ward1b	Joint Ward	Green

Any help would be much appreciated

[jvishnuram]

Then you need to code the same in the script itself.

[c_gilbert]

How? in the real document the data is coming from SQL tables which are updated each day.

[#4]

I reckon you can't do much unless your data are strictly ordered or Ward IDs are linked together

regards

Chris

[#5]

Hey

can you please check the attachment.

Thanks

Angad

[c_gilbert]

Same as previous reply - doesnt work when re-ordered.

[#7]

Then you have to use the same logic in script itself. using peek/previous functions. since we are using above() function which is chart level, and any change in sorting would effect it.

[c_gilbert]

I'm not sure how this would work, as all our data is at record level, and is loaded from qvd files.