I have a production reporting file showing the budget and actual throughputs by product and production center, and I want to calculate the actual to budget variances. The field 'Source' contains 'Budget' and 'Actual', and to this field I have added the calculated item 'Variance'. All of this works fine. What is incorrect is that Variance displays for all products and under all production centers. In the attachment, the product Frame is made in the Welding center and Wheel is made in the Assembly center. But the Variance field for Frame also shows under Assembly and the variance for Wheel shows under Welding. Why is this happening and can it be fixed? The final report will have hundreds of rows of data and we will want to filter on the production center, but with many products per center it would not be practical to subsequently filter on the product.
Thanks,
John
Thanks,
John