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
Post a Comment