Hi,
I have a crosstab query that looks much like this:
TYPE....JAN...FEB...MAR...APR...MAY...JUN...
Valid....157...465...789...154...459...489...
Inval.....15.....48.....48.....15.....46.....51....
Is it possible to have two rows underneath, one, a totals row to show total records per month and another to show percentage of totals which are valid???
Thanks
I have a crosstab query that looks much like this:
TYPE....JAN...FEB...MAR...APR...MAY...JUN...
Valid....157...465...789...154...459...489...
Inval.....15.....48.....48.....15.....46.....51....
Is it possible to have two rows underneath, one, a totals row to show total records per month and another to show percentage of totals which are valid???
Thanks