Hi, The initial of the code should be modified, so here is only the essence of one of the pivoting reports: for $singleDataType in $dataType
for $singleDevice in $device
for $singleAvailability in $availability
for $singleCountry in $country
for $singleParameter in $parameter
group by $singleDataType,$singleDevice,$singleAvailability,$singleCountry,$singleParameter order by $singleDataType,$singleDevice,$singleAvailability,$singleCountry,$singleParameter
return <Row DatasetType="{$singleDataType}" Instrument="{$singleDevice}" Availability="{$singleAvailability}" Country="{$singleCountry}" Parameter="{$singleParameter}" NumberOfRecords="{count($current-pre)}"/>
Other report will count all records with one less condition:
group by $singleDataType,$singleDevice,$singleAvailability,$singleCountry order by $singleDataType,$singleDevice,$singleAvailability,$singleCountry
return <Row DatasetType="{$singleDataType}" Instrument="{$singleDevice}" Availability="{$singleAvailability}" Country="{$singleCountry}" Parameter="Any" NumberOfRecords="{count($current-pre)}"/>
I hope it's clear.
With kind regards, Menashè