does anyone have any BAQs that they use for Trend Cost anaylsis of products.
If you are looking at manufactured products - use the jobassembly table.
You can pick up the costs on all jobs both estimate and actual,
Make sure to filter the results to look at assembly zero for the overall cost.
because of the size of the file, consider putting in a dashboard with a list of product group that is broadcasted and have the above query subscribe to the product group.