How to Apply Rangesum function with 2 dimensions (Year and Month)

[vinayvishwanath]

Dear All,

I am trying to create bar chart with 2 dimensions (Month and Year) wherein the measure is rangesum of employees.

Rangesum should work in such a way that it accumulates the values of Employees monthly and in the chart x-axis should be month and values should show on accumulation basis...If you look into the below table, if the user selects 2018 then bars should be visible with Months showing accumulated values like Jan - 15, Feb - 26, Mar - 44....

Please help me to resolve this issue

	2018	2019
Jan	15	13
Feb	11	10
Mar	18	23
April	31	16
June	19	22
July	2	8
	96	92

[StarinieriG · Accepted solution]

Hi,

try to see the file attached

[vinayvishwanath]

Hi,

I was able to achieve that by adding script in the backend and then using if condition in the frontend.. Thanks for the help in providing the solution for the same