Multiple filters to countrows into new table

[raddy]

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!~

[v-yuta-msft · Accepted solution]

Hi raddy,

Click query editor, filter status column by "Open":

 

Click Transform-> Pivot Columns as below:

  

Hope it's helpful to you.

Jimmy Tao