Put a condition on a dimension

[#1]

I have created a pivot table that contains the following dimensions:

Division, Item, and Measure.

The other items are expressions that contain calculations based on what the user inputs for the year & quarter.

My dilemma is that I don't want items to appear if the shipment quantity for that item is 0.  For instance, if the '2014 Q1 Data' column has 0 for the item then I don't want the item to appear at all.

Here's what the chart looks like:

I have tried the enable conditional on the item dimension but it's not working.  Any other suggestions????

Here is what I put in the enable conditional:

=sum({<FYEAR={$(vCompYr)},QUARTER={$(vCompPrd)},Measure={'Shipment Qty'}>}(Value))<>0

[sunny_talwar]

For each of your other expressions (except 2014 Q1 Data) you can use the following if condition:

=If([2014 Q1 Data] > 0, yourExpression)

Here [2014 Q1 Data] should match the exact label for the expression you want to use (hint: [2014 Q1 Data] will turn blue when it exactly matches the label)

HTH

Best,

Sunny

[Anonymous · Accepted solution]

Or you can try to replace Item dimension with calculated dimension (and label it Item):

aggr(if(sum({<FYEAR={$(vCompYr)},QUARTER={$(vCompPrd)},Measure={'Shipment Qty'}>}(Value))<>0,Item),Item)

As always with calculated dimensions - don't forget to check "Suppress when Value is Null"

[#4]

when I do the calculated dimension, it won't give any items at all

[Anonymous]

I would create a flag (1 or null) in the script at item, fiscal year, qtr (lowest level) based on whether shipment qty is 0 or not and use it in the calculated dimesion for item

[Anonymous]

Why not?  Can you upload an example?