Hi Steve Gesuale

please see the attached workbook and let me know if this is what you are expecting?

Thanks & Regards

Madhu K

Hi Steve Gesuale

I doubt we can achieve what you needed. if you interchange country with region as your parameter then  you can show all the countries within the region.

reasons:

1. We have country parameter and mapping it in the calculation to bring its corresponding region.

2. your parameter and filter is already filtering the country data.

3. We can use LOD's to exclude this filter. But, we cant bring all the countries within the region even with LOD's.

Hope this helps to understand why we can't.

Thanks & Regards

Madhu K

Hi Steve,  I have shown two ways of doing this.  Window calc and LOD.  Hope this helps...

Thanks,

Mohamed

Hi Mohamed Thahir Gaffar Hussain

can you please post the workbook here..i would like to see how it can be done.

Thanks & Regards

Madhu K

Mohamed Thahir Gaffar Hussain

I can see the workbook now. Thanks for the solution, i thought with Max we will get only one record in LOD. but, that is wrong.

Appreciated for your answer it helped me.

Thanks

Madhu K