Chart Dimension should be restricted by Expression Availability

[Anonymous]

I have a chart with Dimension as Material(A).The Expression are Consumption(B) and Consumption Limits(C).

Now I don't have all the Consumption limits(C) available readily for all the Material(A).

I should show only materials(A) which has Consumption limits others should be hided.

When the consumption limits is available then we can show the other Materials(A).

In other words Material (A) which doesnt have Consumption limits(NULL or Zero) should be not shown in chart

What formulae or calculated dimension should be written in the chart.

[Mark_Little]

Hi,

I would use a calculated dimension, something like

IF(ISNULL([Consumption Limits]) = 0 or [Consumption Limits] <> 0, Material)

Mark

[sunny_talwar]

I think you can adjust your expressions to handle this as well:

1st Expression for Consumption:

If(Column(2) > 0, ConsumptionExpression)

2nd Expression for Consumption Limit:

ConsumptionLimitsExpression

and then make sure to have 'Suppress Zero Values' checked on the presentation tab.

NOTE: it is important to have order of expression right because we are using Column() function. Here it is checking if Column(2) (the expression for ConsumptionLimitsExpression > 0 or not) So if you change these two expressions around then use the column number for your consumptionLimitsExpression.

I hope this will help.

Best,

Sunny