Ranking the top Comments 3 by month

[tinkerz1]

Hi,

I have written a formula that I place as an expression in a straight table, the formula shows the top 3 comments by month.

The problem is the report is still showing blank rows for all the other comments.

The results are correct but I can't remove the blank rows, in the presentation tab both suppress zero values and suppress missing are checked and in the dimension suppress when a value is null is also checked.

How do I remove the rows, and why are the empty rows showing? Have they be calculated somewhere are being held in memory?

Thanks,

Expresson formula

if(RANK(Count({1<OverallOutcome={'Upheld','Partially Upheld'}>}[PrimaryComplaintType]))<4,Count({1<OverallOutcome={'Upheld','Partially Upheld'}>}[PrimaryComplaintType]))

[Anil_Babu_Samineni]

You may check dimension level.

Select OverallOutcome -- Use Supress from Dimension

[tinkerz1]

I added OverallOutcome and suppressed the values but still blank rows

[Anil_Babu_Samineni]

Can you share the screen shot?

[sunny_talwar]

Do you have more then 1 expression in your table? Have you made sure that all other expressions also have the same if statement so that they are also null?

[tinkerz1]

Just a single expression, the 2 dimension are not calculations.

Resolved_Month and PrimaryComplaintType

[sunny_talwar]

Do you have a background color expression which might be using RowNo() function by any chance?

[tinkerz1]

I don't have any color expression selected

[sunny_talwar]

Would it be possible for you to share a sample?

[tinkerz1]

Hi,

Here is an example of rows not being reduced. Dimension and Expression are both suppressed.

Thanks,

Neil.