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
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.