Active Report Dynamic Calculations

[abhinadig]

Hello All,


There is an requirement in active reports where i will need to populate date in graph based on user selection.
So for example user selects YTD then i need to calculate and display some average month wise in the chart.

As of now in our active report we have separate row of data for every month and we fetch that row data based on the text YTD as we have YTD value in one of the columns.

Example:
YTD January 20%
YTD February 10%

This is just an example. But when it comes to storing data like above for each calculation then the data count will be in lakh. So can someone please guide how can i dynamically calculate the month wise average on selection of YTD option and present the same on chart.


As of now also we are using Data Deck for these mapping purpose where the label YTD is being mapped to the data item having YTD as its column value as shown in above example.
But here my requirement is not create a record for each things. I need to know is there  a way where i can do calculation with the existing data in Active reports and present on chart.

I hope i am clear with the requirement.

Need help!