This content has been marked as final.
Show 2 replies

1. Re: Excluding a filter on a line graph?
Simon Runc Jul 10, 2017 8:54 AM (in response to Luke Sirakos)1 of 1 people found this helpfulhi Luke,
So this should do the trick for you...
If you want a value to not be affected by a regular filter, it will need to be a FIXED LoDs (these are calculated before any filters are applied). I've used the following calculation
[Avg Sales  SubCategory in Category LoD]
{FIXED [Category], DATETRUNC('month',[Order Date]):
AVG( {FIXED [SubCategory],DATETRUNC('month',[Order Date]): sum([Sales])})
}
So the inner part is doing the SUM by Sub Cat and Month...and then the outer part is taking the average of that value and applying it to the category. A bit of a brain teaser this one, but hopefully makes sense?
Let me know if not.

2. Re: Excluding a filter on a line graph?
Luke Sirakos Jul 10, 2017 9:03 AM (in response to Simon Runc)Thanks Simon and great explanation! That really helped!