Skip to Content

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

Sum DistinctCount and percentage


I am trying to to calculate the percentage on each line of this example...

               Units     Percent

Office 1     10     45,45%

Office 2     12     54,55%

Each line "Office x" is a group where units are a distinctcount of a field.

I need to get the percentage respect the sum of units column. Note that it is not the same sum units value of each line

that a global distinctcount for all records.

I don't know how to get the sum of 10+12 in each line to calculate the percentage.

Thank you,


Former Member

Helpful Answer

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