Skip to Content
0
Aug 18, 2023 at 01:47 PM

Counter of unique values

71 Views

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):

image.png

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

image.png

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.

image.png

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

image.pngimage.png

2. Calculated KF

image.pngimage.pngimage.png

Thanks in advance for any advice.

Regards,

Laurence.

Attachments

image.png (16.0 kB)
image.png (24.1 kB)
image.png (33.4 kB)
image.png (32.3 kB)
image.png (12.5 kB)
image.png (12.9 kB)
image.png (15.7 kB)
image.png (8.2 kB)
image.png (6.2 kB)
image.png (13.7 kB)