Set Analysis - Uniques

[tarngmyna]

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!

[Aditya_Chitale]

Try this:

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

If this is not what you were looking for, pls provide sample data set and expected output.

Regards,

Aditya

[sidhiq91]

@Aditya_Chitale you can use the below set Analysis.

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

Hope this resolves the issue.