Get a table summarize with two fileds

[Anonymous]

Hi, I have a table like below. It is a part of table. The table are more data.

I created two measures. The first count the process opened and the second count the processes closed.
Now I need to build a table like below ,for exemple.


I tried to used summarize and summarizecolumns and yet both, but i can not to build the table. Someone can help me. Thanks

[Icey · Accepted solution]

Hi @Anonymous ,

Please check if the attachment is what you want:

Best regards

Icey

If this post helps, then consider Accepting it as the solution to help other members find it faster.

[Fowmy]

Calculate the expected result based on your sample to understand the logic 

[Anonymous]

I already change the tables images. Can you help me?

[Fowmy]

@Anonymous 

I think your 2nd table data is not based on the sample provided in the 1st table. Can you explain how you calculated 4 Opened and 5 Closed for the 1st row?

________________________

If my answer was helpful, please click Accept it as the solution to help other members find it useful

Click on the Thumbs-Up icon if you like this reply 🙂

Website YouTube  LinkedIn

[Anonymous]

The data are exemples. They are not correct. I just put same data.