Multi Count Summary Calculation?

[Gareth Horton]

Scott Gorder wrote:
> I have a report that lists:
>
> -->Acct Mgr#, Account#, Invoice#
>
> I need to summarize the list down to show:
>
> ==>Acct Mgr#, <Unique Count of Accounts per each Acct Mgr#>, Count of Invoices per Acct Mgr#
>
> The count summary counts 1 for each unique invoice (each line in the table). I need this but also need a count for each unique account in the summary. For example Mgr1 has account 12345 that has 3 invoices listed on the report and account 98765 that has 2 invoices listed. I need the summary to collapse down to show:
>
> ==>Mgr1 has a summary of 2 unique Account#s and 5 unique Invoice#s
>
> Thanks,
> Scott

Hi Scott,

Since you only have the ability to use the "count" to summarize once in each Summary Window tab, I would suggest exporting this Summary. Bring the new file back into Monarch, build a simple Model to pick up the data, and now create a Summary using the "count" on the other field.

I hope this is helpful.

Dee Moore
Datawatch Corporation
Technical Support & Model Building
978.441.2200