MTD Calculation

[stephenedberkg]

how to calculate the MTD values .If i select the January mean it show the January sales values after that i select the FEB mean it show the FEB sales Values only BUT i want the addition of all previous month sales value  .

Eg:

I select the May month sales mean I want Jan,Feb,March,April And May Months sales Vales.

[its_anandrjs · Accepted solution]

Hi,

In your expression try this expression

=Sum({$<Month = {'>$(=Min(Month))) <=$(=Max(Month))'}, Year = {'$(=Max(Year))'}>}  Metrics )

Regards

Anand

[stephenedberkg]

Thank you for reply Anand Chouhan