How can I remove the rows with no data from appearing in my reports?

[hmcquaid]

I have the following report that returns to me the number of records with a certain division status, but it returns me the "station" row even if there is no data in that row.
Report:

Report settings:


Division is an Enum that can either be Amazon, or some other value.
Station is an enum. All possible values for station are being shown on the report even if there is no data for that station.

I have tried to add complex expressions to the COUNT Column in order to check if it is 0 and return NULL if its 0 but that resulted in all 0s in my report.

Thanks in advance for any help!

[rabii]

Just add a filter for Station exclude none

[hmcquaid]

Thank you so much! Such a simple solution!

[rabii]

you are welcome