Multiple filters to countrows into new table

I have multiple columns in a table that I would like to filter and count.

I would like the new table to show only 'Open' Status and count the TRUE fields
The final table(s) would look like:

(1 Table)

Severity |<1MTH|>1MTH|.....

Major     |     2      |    0

Minor     |     9      |    0

or

(2Tables)

'Open-Major Table'

<1MTH|>1MTH|.....

     3      |    0

and

'Open-Minor Table'

<1MTH|>1MTH|.....

    9      |    0

How do I go about doing so? Thank you!~