Hi,
I have a straight table as shown below.
fig.1
Dim1 | Dim2 | Date |
Abi | | 2/2/2013 |
Christy | | - |
Ronald | | 6/6/2012 |
Venkat | | 5/10/2013 |
Jim | | - |
Jeremy | | - |
Now i want to show only the rows that has no date(i.e date is null)
I added an expression like (if (len(date)=0,1,0)). I got as shown below.
fig.2
Dim1 | Dim2 | Date | test date |
Abi | | 2/2/2013 | 0 |
Christy | | - | 1 |
Ronald | | 6/6/2012 | 0 |
Venkat | | 5/10/2013 | 0 |
Jim | | - | 1 |
Jeremy | | - | 1 |
and then I checked Supress Zero Values in presentation tab.
the result i got is,
fig.3
Dim1 | Dim2 | Date | test date |
Christy | | - | 1 |
Jim | | - | 1 |
Jeremy | | - | 1 |
Now, the problem is when I tried to give alternate row color using the expression if(even(rowno(total)),rgb(255,255,0)),again the rows with date are coming up. like the second fig.I want the rows in figure 3 to be colored alternatively not fig 2.
Any idea on this is highly appreciated.
Thanks,
Prem.