Running Total By Month

[#1]

Hello Everyone,

I am trying to find Running total from daily Data (Same as MTD Calculated in Load Script).  I can get data by rangesum but I am stuck on my Running total should reset on the first Business date of the month.

1.  Running sum by month should reset to first business date of the month

2.  Even though the trending day changes it should Calculate correct Running Sum starting from Begining of the month.

3. In the currect selection I have selected trending days 30. So my range of data shown is correct in the table from 4/16/2014 to 

   5/15/2014.

4. For 4/16/2014 it should be 720 as highlighted in Data File

5. on 5/1/2014 it should be 8

6. on 5/9/2014 it should be 359

7. For 5/15/2014 it should be 635

Please see attached sample Data and QVW. I hope I explained it properly.

Thank you all in advance.

[#2]

Hello Devang,

Thank you so Mauch,

This is what exactly, I was looking for,

Amazing!!!!, Really appreciated.

Thank you so much...

Pat