3 Replies Latest reply: Feb 23, 2017 2:23 PM by Rupam Das RSS

    Circular reference caused by common date field and productid. How to fix?

    Anat Dagan

      I am trying to build a dashboard that includes sales and salary information for teachers in several locations, who teach various courses (ProductId).

      I want to analyse the teachers' salary costs (SalaryMonthlyCost) with regards to revenue generated from courses they teach (TotalSoldIncVAT) in relation to ProductId, locationId and other parameters.

       

      As a result i have a circular reference that I don't know how to resolve because both "naughty" fields are truely linked:

       

      I need the date field in common to be able to compare sales with salary costs across time.

      I need the product id to be in common in order to compare costs vs. revenue per product id.

       

      Anyway around this?