We have used the Pivot Table reporting option to generate summary reports. When we include Collection Point Label, the Collection Point Label appears to be ordered alphabetically. Is it possible to configure the report such that the Collection Point Label is ordered chronologically?
It looks like Collection Point Label is excluded if no specimens have been collected for the specified event. Is it possible to include the Collection Point Label for a particular event if specimens haven’t yet been collected (i.e. a row of zeros)?
A screenshot of an example Pivot Table is attached for reference. Identifiers have been removed.
