All tasks, no subtasks into a report or dashboard

pyou

How can i get all tasks from various sheets into a report, without the subtasks. They have the same columns. I want to view the Gantts for all tasks without the subtasks taking space.

James Keuning

Add a column called Level and put this in it: =COUNT(ANCESTORS([Primary Column]@row))

Filter on that column, Level = 0

pyou

I added a column called Level. Every row in that column i paste the formula comes back as unparseable