I need to Show all rows with no data in Pivot table with 0

[niloufar]

Hi experts,



My pivot table shows all my data till I add data into my column field or report filter, then it will only displays rows that have related data. If I change any column or row to "Show items with no Data" it repeats all the data in different categories.

I would like to be able to see all users who is registered or not, who has taken the course or not... so all names from any location and any role who is on the file would like to be seen, but those who have completed the filtered-course gets 1 and the rest get 0.

problem is here that when I filter the course, people who don't have related filtered-course disappeared, but I wanna see them just in case if they are not being registered or not taken the course in system get fixed.

Thank you very much for your help .

[June7]

Need a dataset of all possible employee/course combinations then include that dataset in the query, join type: "Include all records from EmployeeCourses ... " and do a compound join on the employee and course fields.

That dataset can be created with a query that includes the Employees and Courses tables without a join. This will cause a Cartesian relationship of records - every record in each table will join with every record of the other table resulting in every possible combination of employee and course.