Ive a table component with 2 dimension:
Dimension 1: Combination of Company code + Vendor ("'BKPF".BUKRS||BKPF.LIFNR)
Dimension 2: Count of documents (COUNT(DISTINCT BKPF.BELNR))
However Im unable to filter the Document count with count > 1. The system returns the error An aggregate is not a function. Please check that there are no dimension and aggregations used together as function inputs.
Can anyone suggest how to achieve the filter?
FILTER PU_COUNT_DISTINCT(DOMAIN_TABLE("BKPF"."BUKRS", "BKPF"."LIFNR"), "BKPF"."BELNR") > 1;Hello David,
Thanks for your reply. Your suggestion seem to work but I see different results for COUNT(DISTINCT BSEG.BELNR) & PU_COUNT_DISTINCT(DOMAIN_TABLE(BKPF.BUKRS, BKPF.LIFNR), BKPF.BELNR). COUNT(DISTINCT) function returns correct value but PU_COUNT_DISTINCT is returning incorrect value.
Any idea why? Can you suggest where can I find some examples to understand how PU_COUNT_DISTINCT function works?
Regards,
Vijay Segu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.