Is it Possible: Different Data in Rows in a Matrix

[comish4lif]

I'm trying to recreate a table from Excel.

Basically, this table has column Headers of Month and Date (I have that worked out).

But the original table has a row of the count of requests logged in that month.

The second row would be the count of requests closed.

The third row would be some other status.

The original logic is using a SUMPRODUCT on a date field and a status column. I'm pretty sure I can create the calculation for each individual row, but how to "stack" the different counts?

What is the best way to approach an issue like this and create a similar table/matrix? 

[v-chuncz-msft]

@comish4lif,

You may use SUMX Function instead.