8 Replies Latest reply: Mar 26, 2013 7:56 PM by Michael Solomovich

# Surpressing certain values/dimensions in chart

I have the following chart:

Type: Line Chart

dimensions: Years, Product

Expression : Sum(Sales)

Basically I want to surpress any product that doesn't have at least 10,000 in total sales across all years I have selected.

• ###### Re: Surpressing certain values/dimensions in chart

Use Dimension limits.

Show Only Values that are and set Greater 10000 with exact amount

• ###### Re: Surpressing certain values/dimensions in chart

looks like this must be a different version. I don't see dimension lmits as a tab. We are using version 10.

• ###### Re: Surpressing certain values/dimensions in chart

Yes its version 11.

For 10 there will be no option like that. You have to do restriction in expression.

If(Sum(Total<Product> Sales)>=10000,Sum(Sales))

Hope it helps

Celambarasan

• ###### Re: Surpressing certain values/dimensions in chart

I think this is on the right track but it is totalling for ALL products. I want it to evalutate product by product.

for instance we have 12 products. I want each product to show in the line chart UNLESS it has less than 10,000 in sales

• ###### Re: Surpressing certain values/dimensions in chart

i need to know where it fails for you?

• ###### Re: Surpressing certain values/dimensions in chart

Try to replace your Product dimension with this calculated dimension:

aggr(only({<Product={"=sum(Sales) > 10000"}>} Product),Product)

and, don't forget to check "suppress when value is null"

Regards,

Michael

Edit: now you can have more fun if replace constant value 10000 with a variable, and create an input box or slider where user can change this limit.

aggr(only({<Product={"=sum(Sales) > \$(Limit)"}>} Product),Product)

• ###### Re: Surpressing certain values/dimensions in chart

Micheal -

All I have is a line chart with

Dimension- =aggr(only({<[Product]={"=sum(Sales])> 10000"}>} [Product]),[Product])

and

Expression = sum([Sales])

I get No data to display ( when I check "suppress when value is null")

• ###### Re: Surpressing certain values/dimensions in chart

You have also Year dimension, don't you?  What if you add Year to aggregation in the expression for Products:

aggr(only({<[Product]={"=sum(Sales])> 10000"}>} [Product]),[Product],Year)

What if you change 10000 to a lesser limit?

If nothing works, attach a sample application.

Regards,

Michael