Hi Steve!

Thank you very much for your help!

Cafc

Hi, Steve

Thank you very much for your reply. Indeed, all my Measure.Sales has values >0... so the result is not what I would expected!

But, thanks any way.

Hi Dirk Wegener, adapted...

Hi,

thank you very much for both your replies!

I haven't the opportunity to test it but i will tomorrow and post here the results! thank you again

Cafc

hi!

ok! it count, but it is not accurate... i don't figure out why.... ! but i will do it...for sure!

i want thanks to all that answer to my post...

sorry but it return the following error :

"the measures hierarchy already appears in the Axis0 axis."

thanks

i want count the number of costumer by age group, by store and date (of course that is implicit that the costumers has sales...)

in my date base i have the...

if you want to see what's going on you could please visit this link:

http://img84.imageshack.us/img84/3012/mdx.png

the mdx code that you provide generate the result that i show on this picture....

it return the following error:

"the function expects a tuple set expression for the argument. A string or numeric expression was used"

hi,

i try your code as followed:

SET FilteredSet AS filter (

[Dim Costumer].[Cod].ALLMEMBERS,

[Dim Costumer].[Age Group].CurrentMember.Properties("Age Group") = "0-14" and

[Dim Store].[Store Cod].CurrentMember.Properties("Store Cod") = 4

)

MEMBER [Measures].[x]...

hi Barry Ralston,

i try to use the measure count as you said... but this measure will count the number of sales of costumer and not number of coustumers.... you see?

thanks...

thank you very much for your answer!! but can you explain me better your code? can you please explain me what do mean by [DMCount]?

do you mean to this...

Thanks for your answer but your mdx code will return sum of sales... and i want count the number of costumers...

A change my initial post because it wasn't well...

hi steve!

Ok! I didn't have the opportunity to try-it (to create a named query) but I will! but for the moment the hierarchies solve a lot my pbs!! 🙂

Thank...

Hi Steve!

Yes, I agree with you! Its better using hierarchies, I forgot completly the hierarchies !!!! (I have some, but never using/need them, until now 🙂 ) .

But, just for...

Hi, thank you very much for your answer!

Indeed I had already tested the query that you write! but it doesn't return what I want! select top 1... it returned...