Set Analysis - Uniques

[tanalgaov]

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!

[cristianj23a]

To remove duplicates you must add the DISTINCT code to the expression.

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

In case it is not what you require, you can give me more detail with examples.