I have a QV Sales model & I also have a Sales Budget that was done in Excel. I don't know how to add the budget to this model without having loops etc.
I am attaching the table viewer that shows the Sales QV Model as it is at the moment. You will also see that there is a seperate Budget table in the table viewer (this is the excel file I mentioned). I have added "%" infront of every field so that it do not create loops etc.
I need to link that budget to the indicated fields if possible.
If someone could advise I would appreciate it alot.
no same fields ? that's strange. Usually, the main task is comparing budget and Sales amount.
so you should have several same fields, for example: TransDate, Customer, Item etc...