Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
I am so confused Bill... what in the world happened here?