Hi all, I have a circular reference, but I'm not sure how to get rid of it while keeping the data in the structure that I need.
Let me explain:
ItemDim is a list of items and item codes, and the sales data for those items is in SalesFact.
ItemCategories is an excel doc that links item numbers to a Product, like item 5688 is under the Mobile App Product.
The $Syn 3 table was created because of my circular reference.
Cases and Projects are a list of cases/projects, that are also tied to a product, but this tie-in is not through the previous excel doc, but a different hardcoded method (if case# = 2221, then Mobile App).
In my document, I need a chart that shows values for cases and products, and puts it against data from item revenues. The issue is, in order to have these on one chart with the correct values, I need to combine the Product List from Items and the Product List from Cases/Projects.
I created a TestFinalProduct table, and called it the same thing in both sections, but it gave me a circular loop.