Count frequency of values calulcated

billuran — Wed, 25 Nov 2020 16:16:04 GMT

Hello, I have a data set basic description:

Date,ID,Values

I want to then create a table that has field called AGGRValue with integers 0-100

I want to then count the number of dates where the sum of values for each total date equals the AGGRValue

So if 55 dates sum to 99 each then I want the frequency of dates to be 55 and where 25 dates equal the sum of 1 each it will show 25

Example Chart I would like:

AGGRValue	Count the number of dates that equal teh AGGRValue
0	1
1	25
2	4
...	45
99	55
100	23

Thank you for your help!

Re: Count frequency of values calulcated

sunny_talwar — Tue, 24 Apr 2018 21:12:26 GMT

I am so confused Bill... what in the world happened here?

shiveshsingh — Wed, 25 Apr 2018 06:25:51 GMT