hide/suppress dimensions based on expression values

[Anonymous]

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?

[sunny_talwar · Accepted solution]

May be use the column check for all your expressions:

If([Available Resoruce] >= 5, YourExpression)

[Anonymous]

Do i need to add this in the conditional box above the expression box?

[sunny_talwar]

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.

[Anonymous]

Hi Sunny

Thanks. I have added the condition to every expression and suppressed the null values