Not to SUM for an specific Dimension member

[#1]

Hello

I am using the following to SUM for only an specific dimension member:

=sum( {<Dimension1={Member1}>} Sales)

Now, I want to accomplish exactly the oposite, which is, NOT SUM for Member1

Any ideas??

thanks

[thomas_skariah]

Hi,

Try this code

=sum( {<Dimension1-={'Member1'}>} Sales)

Regards,

Tom