New column

[AjithTravvise]

Hello, 

     I wanted to create the 3 new colums(Confirmed/ Recovered/ Deceased) from the list in status column(Confirmed/ Recovered/ Deceased) and corresponding counts against the States. IS there a way to do this.

[harshnathani · Accepted solution]

Hi @AjithTravvise ,

Please see if this helps.

https://www.youtube.com/watch?v=4vfAz7XDuH0

Regards,

Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!!

[zaza · Accepted solution]

Select the Status column, under the transform tab in the top navigation there is the option "Pivot Columns". Click it and then in the pop up select the Count column as value. 

[harshnathani · Accepted solution]

Hi @AjithTravvise ,

Please see if this helps.

https://www.youtube.com/watch?v=4vfAz7XDuH0

Regards,

Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!!