Stock coverage report

[#1]

Hi!

I have some troubles at this report.

1 - (blue squares) Stock at Totals is Sum(), can i put last-month value to totals?

2 - (red squares) Cant calculate Stock Coverage value, it need: current-month stock / next-3-month sellout

Can someone help me?

[#2]

First question is ok.

solution: //in this case last month of year is March

IF(Count(DISTINCT [Calendar Month])=3

     ,sum({<[Calendar Month]={'Jun','Sep','Dec','Mar'}>} Val)

     ,IF(Count(DISTINCT [Calendar Month])=12

          ,sum({<[Calendar Month]={'Mar'}>} Val)

          ,sum(Val)

     )

)

isnt best solution, but work fine.

still lookin' for second answer.