I am unable to open the workbook. Please provide the another one.
Added an another workbook. pls try to access it.
I have prepared data in the below format:
Month Status Values March Closed 0 April Closed 4 March Modified 7 April Modified 0 March Remaining 22 April Remaining
then i created a calculated field like below:
IF FIRST()=0 Then SUM([Values])
Then you will get the result like this:
Hope this helps.
Thanks Kumar for the prompt and correct reply. It helped a lot.
I am glad its helped you.