Count based on Sum

[gerhardl]

Hi There,

If I have about a million Account Number, each with multiple Transactions, then I can easily calculate each of their total spending by using Account No as dimension, and the expression sum([Trans Amount).

I want to know if I can create a table, where I count the number of Account who have spent within certain brackets. For instance, count the number of accounts where the sum of their Transaction Amounts is between 0 and 100. Then count the number of accounts where the sum of their Transaction Amounts is between 100 and 1000, etc.

Please let me know if this is possible.

Thanks,

Gerhard

[Gysbert_Wassenaar]

It's possible. See attached example.

[gerhardl]

Hi,

Sorry, I always forget to mention that I have QV Personal Edition - so cannot open your example.

P.S. to the moderators - The email notification I got telling me about this reply said that it was received from "Sara Leslie"

[Miguel_Angel_Baeyens]

Hi,

To your PS Yes, you may be getting the name of the moderator approving your content. Hope it will be fixed soon.

Regards,

Miguel