calculated dimension from another chart

[ali_hijazi]

Hello

I got a pivot table with 2 dimensions(ItemID, Date) and 2 expressions (E1, and E2)

this pivot table shows a sample data the following

ItemID     Date           E1          E2

27          28/8/2007     4500      5

27          29/8/2007     -            -

34          28/8/2007     3450     5

34          29/8/2008     -           -

...

now what I want is a clone of this above pivot table but only showing the rows with non null expression values

knowing that the expression E1 is very complex and I forced it to show NULL() if a certain condition was satisfied