Table Chart Conditional Column Question

[#1]

Hi,

I'm having problems using Conditional. e.g. I use a simple table with customers and sales. If I only want to show the columns where sales > 100 I would use "sum(Sales)>100". Unfortunately this isn't working. Someone an idea. Thanks.

Aloah

[#2]

Hi,

This seems to be a duplicated thread, and I sent the following reply to your last thread, did you get it? Did you try it?

Sum(Sales) would be evaluated on a Row Level, so I don't suppose it would work as a condition to switch off a column.

What is it exactly that you're trying to achieve? If you are simply trying to exclude a customer from the table if the sales is less than 100 then you should do this in your expression, not on a conditional show. Your expression currently is probably Sum(Sales), if you'd like to exclude as I said above then change your expression to =IF(Sum(Sales)>100,Sum(Sales)), this should do it for you.

If my assumptions are wrong, you need to let us know what you are really trying to achieve.

Regards,

[#3]

Hello Nigel,

thanks for your help. I was compeltly wrong. Of course I need to do this in the expression.

[#4]

Hi Nigel,

is it possible to supress a complete line with all other expressions?

if table looks like this:

salesper | expr.1 (sum(sales)) | expr..2 (avg(sales))

if expr.1 <1000 the whole row should'nt be displayed.

thanks

Aloah

[#5]

Hi Aloah

Expression 1 would be: =IF(Sum(Sales)<1000,Sum(Sales))

Expression 2 would be: =IF(Sum(Sales)<1000,Avg(Sales))

That should do it.