Table that aggregates panel data by date

[franciscoA]

I want to summarize a panel data series by date. One of the series includes the amounts. The other series includes the dates of the amounts. As it is panel data, the dates are repeated several times. I want to know how much there were of the amounts on the different dates.

The first thing I tried was to select the two series using CTRL, one with the amounts and the other with the dates. Then, using the right click, I opened the series as group and tried N way tabulations. Then I realized that is for two dimensional tables. Later I tried the sumby function but the result I'm getting is not what I want.

Any suggestions?

[EViews Gareth]

Open the amounts series, select View->Descriptive Statistics->Stats by classification, then enter the date series as the series to classify by.