Total value for rendered columns

[kc9400]

Hi all,

I have a list report where I render columns based on the prompt values a user selects and am struggling to get the count column to total correctly (the way I want).

The Employee Count needs to total based on the rendered columns.

The Campus, Badge date, and Employee count are displayed as a minimum in the output but I cannot get the Employee count to total based on the rendered columns.

Has anyone done this in the past?

Thanks

[kc9400]

Ok I've made some progress, but the output is leaving blank rows in between where values are displayed.

I am using something like this for each column:

CASE WHEN ?List Columns? contains 'HR Org Code' THEN [SQL1].[4] ELSE NULL END

But yeah I think this is causing the blank rows to show.