Display Future Months

[cbaqir]

I am building a dashboard that shows a straight table of roles with a negative FTE Variance. I have two dimensions: MonthYear and Role. FTE Variance is an expression that looks at the total of hours of resource capacity/possible working hours minue the total of hours allocated/possible working hours.

It only shows records where the FTE Variance is less than 1 by using the Dimension Limits->Show only values that are Less Than -1 exact amount.

I want this table to only show the records in the future months (to allow the user to identify resource gaps). I was trying to get it to show by using Dimension Limits->Show only values that are Greater than today() on the MonthYear field, but it isn't working.

Help!

[ecolomer]

Try this:

Sum({<MonthYear ={">=$(=Max(MonthYear))"}>}  Role)

for the future Months than selected Month

[cbaqir]

Where am I trying that expression, Enrique?

[ecolomer]

In a pivot table for example

[ecolomer]

Can you see good?

[cbaqir]

So, I have my expression that calculates the negative FTE in the Expression Definition ( $(vHeadcount) ).

I'm confused on where your expression would go...

SUM
(
{$<EFFORT_DATE = {">=$(#vCurrentDate)"}>}
$(vHeadcount)
)