Hello all,
The following formula is not working and I'm not really sure why:
sum({$<[Effective Date]={'=[NextMonth]'}>} [Forecasted_Demand] )
I have a pivot table and in the columns I see months. The formula is intended to be a measure for the next months forecasted demand. Example, in the April column, I want to see May demand etc. My effective date field is correct when I add it to a table and my "NextMonth" field is correct when I add it to a table. But for some reason, the above formula is showing the current months Forecasted Demand rather than the "NextMonth".
The date values are in 'YYYY-MM-DD' format. I've attached an example that shows what my pivot table looks like. The "Next Month Demand" should equal the following months "Forecast Demand".
Any ideas how to fix this?
