3 Replies Latest reply: Jan 12, 2012 11:04 AM by Josh Duenyas

# higher than 50,000

Hi all

I have a pivot table chart with 2 dimensions Industry and Customer and one expression of sum(transaction).

I wish to show only those who had total transactions of 50,000 or more.

The expression if(sum(Transactions)>50000,sum(transaction)) works but  the customers in the dimension who had less than 50000 remain in the list with ( - )  as total on their transactions. I wish to eliminate them from the list.

Any idea how to tackle that?

Thanks

Josh

• ###### Re: higher than 50,000

Hi Josh,

Set the same expression but using set analysis instead of a conditional:

```Sum({< Transactions = {"=Sum(Transactions) > 50000"} >} Transactions)
```

Hope that helps.

Miguel

• ###### higher than 50,000

Thanks Miguel

Actually I resolved the problem and figuered out what I did wrong. See my own reply to myself.

Your solution of course, using set analysis is the a better apporoach and more elegant.

Thanks

• ###### higher than 50,000

Well actually I lied.

In the expression I also have a lcolumn for Invoice number and a column for Department.

When removing those it works fine.

So plese disregard the question.

Thanks anyways.

Josh