How I use total <>, when I change the position of dimensions

[#1]

Hi all,
I have a problem when I use Total in expression, when I change the position of Dimension the value is wrong.

Example: in field of %

COUNT(DISTINCT CONTRACT)
/
COUNT( TOTAL <Address, Age , Sex> DISTINCT CONTRACT)

when I move dimensions (change position from <Address, Age, Sex> to < Sex, Address, Age>)
the sum total of % is wrong (not equal to 100).

Thanks,

[Miguel_Angel_Baeyens]

Hello,

Use a cyclic group with fields Address, Age and Sex fields, and then use it looking something like

Count(DISTINCT Contract) / Count(TOTAL <CyclicGroup> DISTINCT Contract)

[#3]

Hello Miguel,

Thank you very much for your response