Sum amount based on date

ReddyReddy 1

Hi . I have an issue in writing the query for below scenario
CompanyA. Sep 2021. 45000rupees
CompanyA. Jan 2021. 3300rupees

CompanyB. March 2021. 5000rupees

CompanyB. Jan 2021. 6000rupees

Now I need to find the company amount as different if the date is more 6 months . If not sum the amount and show as 1 row

Kamlesh Kumar 3,861 Reputation points

2021-09-07T17:52:13.363+00:00

Hi There,

Thank you for asking this question on the Microsoft Q&A Platform.

We would need more details about your issue, what steps did you try and what is not working, if you can provide more details to understand your issue and accordingly we'll help you to resolve it.

I would suggest to use the XSLT and grouping there, that would solve your question.

Please share what you tried so we'll let you know the correct approach.

Regards,
Kamlesh Kumar

If this answer solved your problem, please click the Verify Answer button (found below the answer) to help other users who have the same question.