Forum Discussion
How to Get Your Question Answered Quickly
Ever wonder why some questions get answered so quickly while others languish or are seemingly completely ignored? Fear not, this article will help guide you into getting your question answered quickl...
Hi All,
I have single table. from that table i want distinct id count and $ amt of the distinct ids. $ amt has to be from single instance.
i was not able to achieve the $ amt part. kindly help me
My Table
| ID | Date | AMT
|
| a | 5/21/2024 | 50 |
| a | 5/21/2024 | 50 |
| b | 5/21/2024 | 55 |
| a | 5/22/2024 | 50 |
| b | 5/22/2024 | 55 |
| c | 5/22/2024 | 50 |
My Output Table
| Date | Distinct Id Count | Sum of Amt |
| 5/21/2024 | 2 | 105 |
| 5/22/2024 | 3 | 155 |
| Total | 3 | 155 |
Regards,
mahendran C
mahendran2006 , Thank you for your post. Unfortunately, it seems like you may have meant to create a new post in one of our Community Forum boards, but instead, you replied to an informational post. Please create a new Forum Post instead.
