Set Analysis - Uniques

[asinameli]

I have a set analysis formula counting Sales from “Germany” as follows:

(Count({<[Country]={‘Germany}>} Sales))

I would like to however only consider the uniques of a third column called “Submissions”. The current selection double counts Submissions.

How might I go about removing all duplicates of a third column / submissions column?

TIA

[chrismarlow]

Hi,

If you are counting distinct Submissions do you need to use Sales?

Maybe;

Count(DISTINCT {<[Country]={‘Germany'}>} Submissions)

Cheers,

Chris.