Count distinct rows into a group

[andrew001]

Group	FIELD1	FIELD2	FIELD3	COUNT
GROUP1	A	A	C	2
GROUP1	A	A	C	2
GROUP1	B	B	C	2
GROUP2	A	A	A	3
GROUP2	B	B	B	3
GROUP2	B	B	B	3
GROUP2	C	C	C	3

Hi

by the above table, I would calculate, in a expression into pivot chart,  the field "COUNT" that has to count the distinct row (FIELD1, FIELD2, FIELD3) within each  "GROUP"

Can anyone help me ?

Thanks

[sunny_talwar · Accepted solution]

May be try this

Count(TOTAL <Group> DISTINCT FIELD1&FIELD2&FIELD3)