Forum Discussion

Anonymous

Not applicable

8 years ago

Filtered Values vs Relevant Benchmark Data - FILTER based on a SELECTEDVALUE?

Hello I wonder if anyone can help me with some ideas, I am stuck! The dataset I'm working with is road accident data in a part of the UK and I'm trying to compare statistics on one route with relevan...

Anonymous

Not applicable

8 years ago

Thank you for your time and thoughts on this.

I followed your advice, it worked well plus it inspired me also to try something else that worked well - I duplicated the table, linked the two identical tables together and used one table for one set of data and the other for the control data.

Thanks again

Marie