Im trying to create a crosstab will different column headings, Ex.
Column Headings -> Special Ed, Ethinicity
Row Building\School-> Return Distinct Count for each column(Category)
I have tried dropping a student count in but I get an errort that Special cant be found. Its like you can only have one column heading.
I appreciate the time and assistance.
Thank you,
Tim :o
Hi
Sounds like this is something that should be possible. Can you give some more details; are you using a relational package, DMR or a cube? Could you draw up what you're trying to get to too so I can better understand what you're trying to do?