# Sum DistinctCount and percentage

Hi,

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,

Francesc