1 of 1 people found this helpful
If you do that though the avg will not reflect the different volumes - in other words USED AUTO will always dominate the values.
You can do it though using a table calc -
something like window_sum(avg([sales]))
Thanks for your reply. I had attempted to use the same and another similar table calculation as you had suggested. However, I was giving me some different results. I ultimately decided to use a stack-bar approach to solve the problem, as it stacks the averages per group (see attached image).
However, the stack-bars lose the trenline per group, which is part of what I wanted to illustrate on the report. I cannot show the tren-line using stack-bars.