Sum DistinctCount and percentage
I am trying to to calculate the percentage on each line of this example...
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.