Set Analysis with exactly all P() values

[#1]

Hi, I have the following table:

SEMENTE	AREA	SACAS/HÁ
SEM 1	1	50
SEM 1	2	60
SEM 1	3	65
SEM 1	4	61
SEM 1	5	58
SEM 1	6	66
SEM 1	7	70
SEM 1	8	56
SEM 1	9	79
SEM 1	10	65
SEM 2	3	50
SEM 2	6	66
SEM 2	7	74
SEM 2	8	50
SEM 2	10	63
SEM 3	1	68
SEM 3	2	66
SEM 3	3	65
SEM 3	4	64
SEM 3	5	75
SEM 3	6	59
SEM 3	7	51
SEM 3	8	53
SEM 3	9	59
SEM 3	10	55
SEM 4	3	56
SEM 4	4	66
SEM 4	5	67
SEM 4	6	61
SEM 4	7	63
SEM 4	8	68
SEM 4	9	66
SEM 4	10	65
SEM 5	1	64
SEM 5	3	75
SEM 5	6	63
SEM 5	8	59
SEM 5	9	55

and I have to show the "SEMENTES" where I have exactly all possible values from "AREA" when I select one of this "SEMENTES"

Ex: When I select the "SEM 2" I have to show the "SEM 1", "SEM 2", "SEM 3" and "SEM 4".

now i'm using the following set analysis:

Avg({<AREA=P(AREACOMP)>} [SACAS/HÁ])

but it's returning the "SEM 5" too.

Someone have an idea to solve my problem?

[#2]

Hi Chintia

area 3,6,8 are in Sem 2 and Sem 5, so is it not right that sem 5 is in there?

Just to clarify, when you select sem 2, the possible area is 3,6,7,8,10 and you want your calculation to work on all of those areas, regardless of semetes right? That looks to be happening, so I'm not sure what the issue is

Joe

[sunny_talwar]

I think what he wants is since Sem 2 has 3, 6, 7, 8, 10 then  only those Sem's which have all these area's should be shown. Sem 5 only has 3, 6, 8 and don't have 7 & 10 so it should be shown. That's what I interpreted from him post.

Best,

S

[#4]

relating tables

[Anonymous · Accepted solution]

Tis expressions works, if I got the request right:

Avg({<AREA=P(AREACOMP),
SEMENTE={"=count(distinct AREACOMP)=count({<AREA=P(AREACOMP)>} total<SEMENTE> AREA)"}>} [SACAS/HÁ])

[#6]

Correct friend sunindia

[#7]

worked!! Thank you Michel!!