Dimension as Filter in only one graphic

[#1]

Hello,

I'd like to have a workspace with two grapics (pivot tables):

1) Shows all revenue by project

2) Shows revenue by projects, but only those aded in the last month, based on a colum on theoriginal data that informs in the data is "NEW" or "OLD".

I'm trying with a simple "DATA="NEW"" dimension, but it doesn't work.

How can I do that?

Thanks!

[#2]

try like that

DATA='NEW'

[#3]

Hun, I was mistaking ' with ".

I might be missing some theory, but tried using a Conditional on Dimensioon and on Expressions, still not worked.

In the end used an "if" in the expressions

Instead of SUM(REVENUE)

used IF(DATA='NEW',SUM(REVENUE))

[#4]

Try this

Sum({$<DATA={NEW}>} REVENUE)

[jagan]

Hi,

If creates the performance issues.  So you can use set analysis

=SUM(<DATA={'NEW'}>}REVENUE)

Hope this helps you.

Regards,

Jagan.