Forum Discussion
Get a table summarize with two fileds
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
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.
5 Replies
- Fowmy
Super User
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 🙂
- Fowmy
Calculate the expected result based on your sample to understand the logic
- Icey
Community Support
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.
