1 Reply Latest reply on Aug 12, 2012 2:13 PM by Joe Mako

    Aligned graphs for each category and one graph for aggregation of entire category

      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

      Rishi