# Conditional suppressing of a row in a crosstab

Hello All

Please point me out How to conditionally suppress a row in a crosstab report based on the content in the crosstab.

i.e

i have such a crosstab

01:00 02:00 03:00 04:00 05:00 06:00 Total ------------------------------------------------------------------------------------------------------------------------ Event X 1 0 0 1 0 1 3 Event Y 1 0 1 1 0 1 4 NOEVENT 1 0 0 1 0 1 3 ------------------------------------------------------------------------------------------------------------------------ Total 3 0 1 3 0 3 10

When the row entry is of "NOEVENT" , then i need to suppress the whole row in the crosstab, including the one reflecting for the **Total**.

01:00 02:00 03:00 04:00 05:00 06:00 Total ------------------------------------------------------------------------------------------------------------------------ Event X 1 0 0 1 0 1 3 Event Y 1 0 1 1 0 1 4 ------------------------------------------------------------------------------------------------------------------------ Total 2 0 1 2 0 2 7

Is such a thing possible ??

If yes ... Please help me to achieve it

Regards

Srivatsa

##### Graham Cunningham replied

Srivatsa,

If the field used as the Summarized field in the crosstab is the same as the field used for rows then the formula would be same as the first one. Please note that the does not equal symbol is read by the forum as HTML and therefore does not appear.

Here is the formula written without using the not equal symbol;

if NOT ( = 'No Event') then

Substitute the row and summarized fields in the crosstab expert with this formula.