Conditional Summation against a Date

[b_garside]

I have a table were I want the summation to only work when a records Month is in range.

My example below I hope illustrates my goal.

The Closed date column should only show a value for Dec 2013 since the opportunity was closed that month.

But instead it shows the value for each month.  The Active column is the inverse were it should show For Oct-Nov.

Active

Sum({<Status_CRM = {"1"}  >}dol_PV_YR1)

Closed:

Sum( {< Stage = {'>=8<=11'} >} dol_PV_YR1)

proposed: lost on this?

If( CloseDate = Max(CloseDate) , Sum( {< Stage = {'>=8<=11'} ,Stage_Gate=,Status_CRM=,Status=    >} dol_PV_YR1)/1000 )

[Nicole-Smith]

Please post a .qvw

Preparing examples for Upload - Reduction and Data Scrambling

[#3]

upload QVW file

[b_garside]

Ok, I uploaded a QVW. Thanks

[Nicole-Smith · Accepted solution]

Have a look at the file I have attached.  It should give you what you need.

[b_garside]

Thanks Nicole!  This is what I needed.