Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be try this
Count(TOTAL <Group> DISTINCT FIELD1&FIELD2&FIELD3)