Hi can anyone tell me how I could use a cross tab to add up the sum of the columns as shown here?
Total Column1 Column2 Total 12:00 4 2 2 15:00 1 1 0
the 12:00 & 15:00 are times of the day and the columns hold the number of entries for the times. The times get their data from from a stored procedure, anyway all I want to know is how to get a grand total for each column. so it would look like
Total Column1 Column2 Total 12:00 4 2 2 15:00 1 1 0
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum