Hi Naveen,

You can either create a screen to insert the monthly data into your database table or import a csv/excel file based on your use case to add the monthly data.

As I can see, you have a Year range filter. You just need to add another Month filter, and based on that, you can fetch monthly data from entity. 

 Let me know if you need more information.

Thanks,

Is it correct that you wanted to sum your monthly data? if yes then you can use Group by with SUM. It will calculate the total sum of monthly data based on the month and year.

Hi, 

You can use a aggregate to fetch the data from entity. In aggregate you can use create a new attribute to sum three month data to show as a revenue of the qtr as per your screen-shot. 

In new attribute, you can rename this sum monthly data and can use on screen to display as column.   

I hope it will help to you. 

Thanks 

There are several approaches. The simplest is to add another aggregate that returns only the sum for each month. Otherwise, you can add another Total (Sum) column to your existing aggregate, but it will duplicate the same value for each row.

The answer is to use structure list where we map data coming from aggregate and same structure we want to loop again.