Sum intersection of item with differents values

[#1]

hello,

i explain you my problem...

I ve an table with  an flag on an counter Of Item and site is an dimensio of the table (Fact_item)

i would like to calculate the intersection of the Item which are with connect to the 00P and the site OOM ....

I don't how to do in set analysis

this formular is the union but i don t know how to do the intersection

sum

({$<[Nb Créa Item]={1},Site={'00P00','00M00'}>} Nb Créa Item

)

do you have any idea?

thanks

[#2]

in set analysis + sign use for union, and * sign use for intersection.

try this(UPDATED)

sum({$<[Nb Créa Item]={1},Site={'00P00'} * {'00M00'}>} Nb Créa Item) 

[#3]

thank but it doesn't work it gives me 0 and i ve checked for a lot of item  i ve the both site  :

For one item ,

sum({$<[Nb Créa Item]={1},Site={'00P00'}>} Nb Créa Item) =1

sum({$<[Nb Créa Item]={1},Site={'00M00'}>} Nb Créa Item)=1 

so the intersection should be more than 0

.....

[#4]

I ve tried this formalar and it s working inside an text object  but when i try to put in an chart it doesn't work ....

Do you have any idea of the origin of this problem....

sum({$<[Nb Créa Item]={1},Site={'00P00'}>*<[Nb Créa Item]={1},Site={'00M00'}>} [Nb Créa Item]

)

cause the dimension are corrects.... cause my result is working with the selection but not in chart...

[#5]

Sorry i ve made an bad manipulation ...

My problem is only when i tried to display on an chart and i try to display ...there is nothing all the result is on other ...

And i ve checked with list of selection, it s working i ve result with the dimension  ...

it s an problem with the object graph i don t know why...

[#6]

nobody has an idea what is the origin of my problem ?