Hi all,
I want to calculate the unique values of sales documents.
Some difficulties:
- the counter has to adjust when a BEx Condition is applied --> I found a solution for that
- the counter should still show only unique value even when I enter an extra detail in teh report on Sales Doc Item level --> I cannot find a solution for that
So example
I have 11 Sales Doc Numbers (after applying a BEx condition):

If I add the detail of Sales Doc Item number to this table, the Overall result of my counter increases from 11 to 14, which is not what I want, I still want to see in the Overall result the 11 unique Sales Doc numbers

If I then remove the drilldown of the Sales Doc number from my table (which is my ultimate goal), again, the Overall result is modified to show basically a count of the Sales Doc Item numbers instead.

Any ideas on how I can keep this 11 units in the Overall result, regradless of the drilldown in my table?
This is how the KF is built:
1. Formula variable


2. Calculated KF



Thanks in advance for any advice.
Regards,
Laurence.