Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Aggregation for unique entires

Hello Experts,

I have requirement to show the number of complaints against Category.

Basically, my data looks like as follows:

Transaction NumberCategory ID 1Number
8000000008Billing1
8000000008Metering1
8000000009Collections1
8000000009CMP1
8000000010Metering1

I want to have table like below:

Category ID 1Number
Billing1
Metering2
Collections1
CMP0

Here, for transaction number 8000000008, there are two categories Billing and Metering and my requirement is to have a table with just Category and Number and for this transaction number either of the category should show 1. Similarly, if there are any other transaction numbers for that category it should those as well.

Basically, it should not consider the duplicate transaction numbers.

I have tried formula - Previous but it works when you have transaction number in the layout. If transaction number is removed from layout. it gives me #Multivalue error.

Any immediate help would be appreciated.

Thanks in advance!

Regards

Lavanya

Former Member
Not what you were looking for? View more on this topic or Ask a question