filter by distinct value

[LauraBecht]

Hi,

I have a table of accounts that have been joined to a table of taxing authorities in a many to one relationship.  I need to summarize by the distinct account for a given taxing authority which has multiple city/mill codes.  is this possible?

Thanks,

Laura Becht

[ScottSandusky]

Hi Laura, will the summary table work for this? Use the variables that you want to summarize and get the distinct counts for?

[LauraBecht]

Hi Scott,
That is kind of what I am doing, but it doesn't allow for a unique count or value sum for the whole tax authority due to the duplicates. What I am looking for is a way to filter the kpi for distinct parcel id's/accounts, kind of like select distinct in sql. I have the summary by tax authority in a summary page, but was hoping to be able to effect the same on the parcel/tpp account page, more so the user doesn't have to switch back and forth.
Laura