how to sum up values based on filter selection

[abubakarsiddiq7]

hi Team,

i have month filter which is having values like Jan,Feb,......Dec.

my requirement is when i select 

feb then my sum(sales) my output should be  Jan month sales +feb month sales.

mar ---then  my sum(sales) my output should be  Jan month sales +feb month sales + month sales.mar 

Dec--->Jan+feb+mar+apr...............Nov+dec month sales.

Thanks in Advance 

[vishsaggi]

You can use Rangesum() with Above() functions to achieve this. Share some sample data to work on.

[abubakarsiddiq7]

HI ,

Please find the sample data.

i need to implement this requirement in KPI object .