Surpressing certain values/dimensions in chart

[zagzebski]

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.

[CELAMBARASAN]

Use Dimension limits.

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

[zagzebski]

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

[CELAMBARASAN]

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

[zagzebski]

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

[CELAMBARASAN]

Can you upload the sample?

i need to know where it fails for you?

[Anonymous]

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)

[zagzebski]

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")

[Anonymous]

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