Forum Discussion

raddy's avatar
raddy
Frequent Visitor
8 years ago
Solved

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 l...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    8 years ago

    Hi raddy,

     

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

     

    Click Transform-> Pivot Columns as below:

      

     

    Hope it's helpful to you.

     

    Jimmy Tao

v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi raddy,

 

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

 

Click Transform-> Pivot Columns as below:

  

 

Hope it's helpful to you.

 

Jimmy Tao