I am not very experienced in writing reports, but have copied another report and amended to get a list of open calls by analysts who work across different teams,.
The report has run but is listing the same call reference a number of times and I am not sure why.
The tables used are
The columns are
The filter is
Everything works as I want apart from duplicate records - I have attached a screen shot of the part of the reports -
Does anyone have any ideas why?