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
I can walk on water when it freezes