I have a double line graph showing SPRs (special product requests) - the top green line shows ALL orders and I want this line to be fixed, the bottom purple line is adjustable and excludes a certain list of vendors (detailed in the caption). I did this using fixed and include functions which you helped me with. If the end user uses the filter to exclude additional vendors, it works fine and the purple line adjusts while the green line stays fixed.
The issue is that if the end user just wants to look at one vendor, for example if they clear out the filter and only select "Abbott Laboratories Inc.", the fixed line also changes. How do we get the fixed line to be truly fixed? Ideally the fixed line would still show the total number of orders for all vendors, and the purple line would only show Abbott orders.
try this as your fixed count
{FIXED [Week] :count([Po Id])}
