Ah sorry ignore the coloring. Each row is a different measure/expression and I would like to show totals for each measure across all companies. So ideally there would be a totals column which shows the totals for each measure. i.e total nav = Company 1 NAV + Company 2 NAV + Company 3 NAV Etc
One more question. My total responds to selections made, ie if I select company 1 the total column will show the same values as just company one. Do you have an idea on how to have the total column show values for the whole data set.