Problem with circular reference

[alnocetti]

Hello good afternoon.

I'm having a problem with a circular reference, I leave attached the catch.

Basically it is an application that analyzes sales, it has customers, items, sales, and a calendar.

The problem is that I was asked for a tab that shows, among other things, the number of active customers (per month-year), for each seller (as you will see, the relationship is one-to-one between seller and customer).

I already have a table (CustomersPerSeller -> (ClientesPorVendedor)), where the fields are: seller, month-year, otal (number of active customers).

Any way to fix it?

Is the correct way a linked table?, should i re-estructure all the data?

Thanks in advance.

[vishsaggi]

I believe your calendrio table should have all the calendar fields. Remove %emp_fecha from your Calendrio script and re run.

[alnocetti]

But i need this table(Calendario) linked to "Ventas" -> (Sales), because every tab in the app, have a date filter, if i remove this field (%emp_fecha), i'll lose those filters.

[vishsaggi]

What field is this %emp_fecha can you share this calendrio script you are using? I want to know from which table source you are getting this %emp_fecha?