Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have created a pivot chart for roles and resource count. I would like to suppress the Roles wherever the available resource count is less than 5.
Dimension - Role
Expression for Available Resources is below -
count
(if(aggr(sum({<PlanType={'Allocation'}>}HCM),[Resource Name] )<=0.7, [Resource Name]))
Can anybody please help?
May be use the column check for all your expressions:
If([Available Resoruce] >= 5, YourExpression)
May be use the column check for all your expressions:
If([Available Resoruce] >= 5, YourExpression)
Do i need to add this in the conditional box above the expression box?
No, this would go in the definition area. You will basically replace your expressions with new ones. Lets say you have an expression Sum(Sales). The new Expression will be:
If([Available Resoruce] >= 5, Sum(Sales))
and so on for all the expressions.
Hi Sunny
Thanks. I have added the condition to every expression and suppressed the null values