i am trying to filter on customer account number and i can not get it to
work -

select

{[measures].[sales]} on columns,

{filter([product].[product description].members, [customer].[customer
account no].members = 1005)} on rows

from [sales]


what i am trying to do is create a 'set' of products that a specific to one
customer


any ideas?

Try this (not promising anything):
select
{[measures].[sales]} on columns,
{filter
CROSSJOIN([product].[product description].members, customer.[customer
account no].members),
NOT IsEmpty(product.CurrentMember,[customer].CurrentMember)
} on rows
from [sales]

What was the "=1005" bit supposed to do?

Hope this helps. Let me know OK.

Regards
Jamie Thomson
http://www.conchango.com


"Jez" wrote: