Set Analysis - Uniques

[patagbura]

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?

[BrunPierre]

Maybe like this

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

[marcus_sommer]

You may try:

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

or if no relevant field like an OrderID exists also the combination of fields like:

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

An alternatively might also be to use two expressions to get the unique count, like:

count(distinct Sales) / count(distinct SalesLines)

- Marcus