Selecting the grand total is essentially like selecting all of the contents in the map. It is selecting all of the values in the source sheet.
Hope this helps!
The Grand total row runs along all 8 columns with each column having a line from 2011 to 2012. I want to be able to clich the line at the 2012 grand total point and see the map show me the 2012 grand total numbers. right now the map is showing the grand total for all 8 columns 2011 and 2012.
Have you got any solution (or) workaround to implement selection on totals and see details of the same.