When we selected any month in parameter then running sum will show correct sum in row.

 

Step:1

Create parameter with month like integer 1,2,3,etc

 

Untitled.png

Step:2

Create calculation [Running sum of month total]

 

if [Month]=12 then (if last()=0  then (RUNNING_SUM(SUM([Sales])))end )

elseif [Month]=11 then (if last()=1  then (RUNNING_SUM(SUM([Sales])))end )

elseif [Month]=10 then (if last()=2  then (RUNNING_SUM(SUM([Sales])))end )

elseif [Month]=9 then (if last()=3  then (RUNNING_SUM(SUM([Sales])))end ) 

elseif [Month]=8 then (if last()=4  then (RUNNING_SUM(SUM([Sales])))end )

elseif [Month]=7 then (if last()=5  then (RUNNING_SUM(SUM([Sales])))end )

elseif [Month]=6 then (if last()=6  then (RUNNING_SUM(SUM([Sales])))end )

elseif [Month]=5 then (if last()=7  then (RUNNING_SUM(SUM([Sales])))end )

elseif [Month]=4 then (if last()=8  then (RUNNING_SUM(SUM([Sales])))end )

elseif [Month]=3 then (if last()=9  then (RUNNING_SUM(SUM([Sales])))end )

elseif [Month]=2 then (if last()=10  then (RUNNING_SUM(SUM([Sales])))end )

elseif [Month]=1 then (if last()=11  then (RUNNING_SUM(SUM([Sales])))end )

End

 

Step:3

Drag the month in to row.

Drag this [Running sum of month total] calculation into row

 

Step:4

Drag this [Running sum of month total] into filter and apply non-null values.

 

Step:5

Show parameter control and select months.