I am trying to create a trend line, but I am having some issue. I have a single measure, but need to have lines for some products, but not all products (the product lines will never change). I need to be able to filter the chart by customer (that part I have), but I also need to display a national trend for the same fitlers products.
Unfortunately for company policy, I can't post the qvw file
If you want to have independent trend lines for some products but not others you might need to create a unique expression for each product using set analysis, or an expression for those with trend lines and one for those without.
Using a set analysis like:
Would produce a line showing the measure for Product A on which you can show a trend line. You can then make the expression invisible using the tick box on the Expressions tab, but the trend line will still show.
Probably not a complete solution but this might suggest a direction you can go in to get the results you want.
Thanks. I was able to get the trend line for the certain products for a given customer, but how can I get a national product trend line? I know where to add the trend, but I need some help on the calculation.