On the Column shelf, I have Year and and Quarters. On the Row shelf, I have Bank (5 banks) and AVG(Net Interest Margin) with Bank being on Color Mark. This gets me the time series for Net Interest Margin for each bank. But below the individual aligned line graphs I would like to get the line graph for Net Interest Margin aggregated (by average) for all banks.
I currently hack it by putting two worksheets on one dashboard. But this isn't fun because the drill downs on Year (if I wish to look at data on yearly basis instead of quarterly) are not aligned.
Any thoughts? Thanks
What if you turn on Grand Total?
(menu option Analysis->Totals->Column Grand Totals)
If you need a different aggregation, or at a different level, or agg of agg in the grand total, see http://drawingwithnumbers.artisart.org/customizing-grand-totals-part-2/ for lots of options.