Limiting Data in a Pivot Chart

[Anonymous]

I have a chart that calculates how many weeks of supply are on hand for all products. I need the pivot to only show those products where the weeks supply is less than 2 weeks but I can't seem to figure out how to do this. Please see the attached screen shot of the chart.

[#2 · Accepted solution]

What you could do is add some logic to your expressions to set them to Null if the supply is greater than 2 weeks. If every expression is Null for a specific record, it will not appear on the chart (if you set hide Null values).

Expression: If("Wk Supply" < 2, Current Expression, Null)

If you set up all the expressions like that, the only records that will appear are the ones with a supply less than 2.

[Anonymous]

Well that was just too easy. LOL

Thanks!