I would personally either add a custom calc for avg in your dataset or create the experssion in the table or text box (depending on whatever you are using of...

Hi Vivek,

Well thats basically it.

I have one dataset just so that I can test.

It has multiple colums and I look at a particulat column that has either Y or N...

Well it would appear that we are having to write our code in MDX and not SQL, so not 100% sure on how to go about this. (My MDX sucks).

I'm...

Excellent, thank you Grasshopper.

I will have a play with it today.

I'm sure I will have more questions regarding this but I will read those articles you have mentioned.

Thanks for you...