Forum Discussion
Helper IVUnique and not unique count
You can't add two "total" rows, but you can concatenate two result together like this. This will give the two results on all rows, but you can use IF(HASONEVALUE() or ISFILTERED() to show two results only in the "total".
Unique/Not Unique =
var u = <unique expression>
var n = <not unique expression>
return u & "/" & n
Pat
Helper IVVahidDM Thanks, this one works perfecly to calculate the non-unique totals! One last question, is it also possible to add an additional row that shows the unique numbers? So that you have two two rows for the totals?
Microsoft EmployeeYou can't add two "total" rows, but you can concatenate two result together like this. This will give the two results on all rows, but you can use IF(HASONEVALUE() or ISFILTERED() to show two results only in the "total".
Unique/Not Unique =
var u = <unique expression>
var n = <not unique expression>
return u & "/" & n
Pat
- Roym
Great, thanks!!