filter - Distinct count a field that has been sorted by territory from another source -


i trying find way distinct count on field being filtered territory without using grouping because of fact need pass value on report. easiest way this:

distinctcount({comm_link.cmli_comm_companyid}) if  {company.comp_territory}='atlanta' 

but obvious reasons won't work. thoughts?

what have running total. right click on {comm_link.cmli_comm_companyid} insert running total, type of summary distinct count , on evaluate says use formula type condition {company.comp_territory}="atlanta"


Comments