It seems this should be a trivial task, but I haven't found a way to do this in Qlik Sense.
Given a two-dimensional line chart that shows revenue by office per month as shown in the screenshot below (and in attachment), is there a way to display not only one revenue line for each office but also a total (or average) revenue line for all displayed offices?
In the above example, I would like to see a 4th line that represents, for each month, the total (or the average) of the revenue for all 3 offices (Chicago, Dallas, Houston). Furthermore, if the user filters on offices to show only Chicago and Dallas, than I would want the total line not to include Houston revenue.
I tried using the Reference Line add-on, but I was not able to make it show a total (or average) for each office, varying from month to month.
Thanks in advance to anyone who can help me with this seemingly simple (but elusive in Sense) requirement.
Thanks, Thomas. I had actually done some more searching and found a similar solution (Net Total line in Qlik Sense line chart), but I appreciate that you spelled it out so clearly for me and that you included the Average option.