Dont show rows

[smilingjohn]

hi All,

In the below table i am displaying a data related to severity, created, summary etc.

My requirement is to show only those rows where Counts is 1 and i dont need to show other blank rows ,\

I tried to suppress the dimension too but this is not working how do i get this done,

The formula for Counts is (If(sum(count)>0,sum(count),'')

Can you expertise please help on this .

Currently this table is diplaying format as shown in the snapshot 

Thanks in Advance

[jaibau1993 · Accepted solution]

Hi!

Try modifying all your expressions like

"if( sum(Count) = 1, your expression here)"

Since the calculation sum(Count) is already being done, you may use something like

"if( Column(Number) = 1, your expression here)"

Where Number is the column number of the "Counts" expression.

Regards,

Jaime.