set analysis issue

[prasadcm]

Hi,

I need something like this,

sum of gl accounts to be divided by specific gl account={32131.4003}

Dimensions are gl account no,name,year & month

I wrote expression as
= sum([Additional Currency Amount]) / sum({<[GL Account No]= {'32131.4003'}>}[Additional Currency Amount])

My output should be

But i get o/p as 

all gl accounts should be displayed.

Regards,

Prasad

[prasadcm]

This works perfectly

Thanks a lot

[sunny_talwar]

No problem at all. I am glad I was able to help

[prasadcm]

it just gives me data related to GL Account No= {'32131.4003'},whereas i need all gl accounts