How to create a column heading for results that can't be grouped?

[rocklee]

This is my query to look up ethnicities of students based on attendance :

TRANSFORM Count([Activity Attendance].AttendanceDate) AS CountOfAttendanceDate
SELECT [Lookup - Ethnicity Code].Eth_name
FROM ([Activity Attendance] INNER JOIN Student ON [Activity Attendance].UPN = Student.UPN) LEFT JOIN [Lookup - Ethnicity Code] ON Student.[Ethnicity Code] = [Lookup - Ethnicity Code].[Ethnicity Code]
GROUP BY [Lookup - Ethnicity Code].Eth_name
PIVOT [Activity Attendance].[Activity ID];

And I use this to create a graph as a result.

However, some students don't have their ethnicities records, which gives out a "SLICE 1" heading for this group. How do I create a row heading like "OTHERS" for this unnamed row?

 

[Guus2005]

Use a query to straighten out irregularities.
Use this query in your final result.

HTH

 

[DCrake]

In your query go to the column field and wrap Nz([Your Ethnicity field],"Unknown") around the field in question. This will then get over the slice 1 issue.

David