Calculating on Crosstab Intersection Values - Part 2

[Guest]

Good Morning,
I had some help early on how to select specific crosstab intersection values
for further calculation, by removing the pivot and transform section of the
query. This left me with the age, the classification and the total count for
each category.

Problem, when i attempt to crete a calculation for, Age 1, Classification =
Routine, i get the value i am looking for, plus 61 additional rows, which i
don't need. I want to be able to create a grid, inserting the calculations i
create, but i am not having any luck.

Can anyone help?

 

[Guest]

Post your present SQL for the crosstab with example of input data, and output
display. Also show what you would like the display to look like end the end.