Counting number of records in a column with a specific text

[jonathonallen]

My workflow output has 12 columns where each record is either "OPEN" or "CLOSED".

How would I create a summarized view where for each of the 12 columns, I can get the total count of "OPEN" and "CLOSED" records?

[bpatel · Accepted solution]

hi @jonathonallen,

here is an idea 

or this view

hope this helps!

[jonathonallen]

This was exactly what I needed. Thanks!

[jonathonallen]

I went with view # 2 in the initial response, and now I want to find a way to add a $$ total (Each record that has the open/close columns also has a $$ total) What would be the best way to add a $$ total for CLOSED records to the summary table? Please let me know if a data sample would be helpful.