Hi. For simplicity, the table has two fields
[location],[type].
SQL = Select loc, type, count[type] AS [number] from table
Group BY loc, type;
assume percent = count(number)/sum(count(number))
On report
GROUP
loc
Detail
type number percent
Report Footer
sum(number) sum(percent)
My problem is with the aggregate sum(percent) since I have already used sum(number) to arrive at percent.
Thanks.
[location],[type].
SQL = Select loc, type, count[type] AS [number] from table
Group BY loc, type;
assume percent = count(number)/sum(count(number))
On report
GROUP
loc
Detail
type number percent
Report Footer
sum(number) sum(percent)
My problem is with the aggregate sum(percent) since I have already used sum(number) to arrive at percent.
Thanks.