Dont show rows

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Dont show rows

jaibau1993 — Wed, 15 May 2019 06:46:00 GMT

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.